Oracle EBS:常用SQL语句(2)
作者:admin 日期:2009-11-11
--1.已审批的请购单 author:dezai
--2.已审批的采购单 author:dezai
复制内容到剪贴板
程序代码
程序代码Select prh.requisition_header_id, prl.requisition_line_id,prh.segment1
from PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL
where prh.requisition_header_id = prl.requisition_header_id
/* and prh.requisition_header_id = 100 */
and prh.authorization_status = 'APPROVED'
from PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL
where prh.requisition_header_id = prl.requisition_header_id
/* and prh.requisition_header_id = 100 */
and prh.authorization_status = 'APPROVED'
--2.已审批的采购单 author:dezai
