DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 188: FROM PO_REQUISITION_HEADERS_ALL PORH,

184: PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND
185: PRL.REQUISITION_HEADER_ID = pReqHeaderId
186: UNION ALL
187: SELECT DISTINCT to_char(OSH.ORDER_NUMBER) ORDER_NUM
188: FROM PO_REQUISITION_HEADERS_ALL PORH,
189: PO_REQUISITION_LINES_ALL PORL,
190: OE_ORDER_HEADERS OSH,
191: PO_SYSTEM_PARAMETERS POSP
192: WHERE PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND