DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on OE_ORDER_HEADERS

Line 190: OE_ORDER_HEADERS OSH,

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
193: OSH.ORDER_SOURCE_ID = POSP.ORDER_SOURCE_ID AND
194: OSH.ORIG_SYS_DOCUMENT_REF = PORH.SEGMENT1 AND