APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 181: FROM PO_REQUISITION_LINES_ALL PRL,

177: SELECT ORDER_NUM
178: INTO xOrderNumber
179: FROM (
180: SELECT DISTINCT PH.SEGMENT1 || DECODE(PR.RELEASE_NUM, NULL, '', '-' || PR.RELEASE_NUM) ORDER_NUM
181: FROM PO_REQUISITION_LINES_ALL PRL,
182: PO_LINE_LOCATIONS_ALL PLL,
183: PO_HEADERS_ALL PH,
184: PO_RELEASES_ALL PR
185: WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND

Line 192: PO_REQUISITION_LINES_ALL PORL,

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

Line 222: FROM PO_REQUISITION_LINES_ALL PRL,

218: SELECT SUPPLIER
219: INTO xSupplier
220: FROM (
221: SELECT DISTINCT PV.VENDOR_NAME SUPPLIER
222: FROM PO_REQUISITION_LINES_ALL PRL,
223: PO_LINE_LOCATIONS_ALL PLL,
224: PO_HEADERS_ALL PH,
225: PO_VENDORS PV
226: WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND

Line 232: FROM PO_REQUISITION_LINES_ALL PRL,

228: PH.VENDOR_ID = PV.VENDOR_ID AND
229: PRL.REQUISITION_HEADER_ID = pReqHeaderId
230: UNION ALL
231: SELECT DISTINCT HAOU.NAME SUPPLIER
232: FROM PO_REQUISITION_LINES_ALL PRL,
233: HR_ALL_ORGANIZATION_UNITS_TL HAOU
234: WHERE PRL.SOURCE_TYPE_CODE = 'INVENTORY' AND
235: HAOU.ORGANIZATION_ID = PRL.SOURCE_ORGANIZATION_ID AND
236: HAOU.LANGUAGE = USERENV('LANG') AND