DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 191: FROM PO_REQUISITION_HEADERS_ALL PORH,

187: PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND
188: PRL.REQUISITION_HEADER_ID = pReqHeaderId
189: UNION ALL
190: SELECT DISTINCT TO_CHAR(oe_order_import_interop_pub.Get_Order_Number(POSP.order_source_id,PORL.requisition_header_id,PORL.requisition_line_id)) ORDER_NUM
191: FROM PO_REQUISITION_HEADERS_ALL PORH,
192: PO_REQUISITION_LINES_ALL PORL,
193: PO_SYSTEM_PARAMETERS POSP
194: WHERE PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND
195: PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID AND