DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 193: PO_SYSTEM_PARAMETERS POSP

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
196: PORH.REQUISITION_HEADER_ID = pReqHeaderId
197: );