APPS.POR_VIEW_REQS_PKG dependencies on OE_ORDER_LINES_ALL

Line 335: OE_ORDER_LINES_ALL OOL,

331: INTO l_so_number, l_status_code, l_line_id
332: from PO_REQUISITION_LINES PRL,
333: PO_REQUISITION_HEADERS PRH,
334: OE_ORDER_HEADERS_ALL OOH,
335: OE_ORDER_LINES_ALL OOL,
336: PO_SYSTEM_PARAMETERS PSP
337: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
338: AND PRL.REQUISITION_LINE_ID = req_line_id
339: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 368: OE_ORDER_LINES_ALL OOL,

364: INTO l_split_line_num
365: from PO_REQUISITION_LINES PRL,
366: PO_REQUISITION_HEADERS PRH,
367: OE_ORDER_HEADERS_ALL OOH,
368: OE_ORDER_LINES_ALL OOL,
369: PO_SYSTEM_PARAMETERS PSP
370: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
371: AND PRL.REQUISITION_LINE_ID = req_line_id
372: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 389: OE_ORDER_LINES_ALL OOL,

385: INTO l_so_number, l_status_code, l_line_id
386: from PO_REQUISITION_LINES PRL,
387: PO_REQUISITION_HEADERS PRH,
388: OE_ORDER_HEADERS_ALL OOH,
389: OE_ORDER_LINES_ALL OOL,
390: PO_SYSTEM_PARAMETERS PSP
391: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
392: AND PRL.REQUISITION_LINE_ID = req_line_id
393: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 418: OE_ORDER_LINES_ALL OOL,

414: INTO l_so_number, l_status_code, l_line_id
415: from PO_REQUISITION_LINES PRL,
416: PO_REQUISITION_HEADERS PRH,
417: OE_ORDER_HEADERS_ALL OOH,
418: OE_ORDER_LINES_ALL OOL,
419: PO_SYSTEM_PARAMETERS PSP
420: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
421: AND PRL.REQUISITION_LINE_ID = req_line_id
422: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 538: OE_ORDER_LINES_ALL OOL,

534: INTO l_so_number, l_status_code, l_line_id
535: from PO_REQUISITION_LINES_ALL PRL,
536: PO_REQUISITION_HEADERS_ALL PRH,
537: OE_ORDER_HEADERS_ALL OOH,
538: OE_ORDER_LINES_ALL OOL,
539: PO_SYSTEM_PARAMETERS_ALL PSP
540: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
541: AND PRL.REQUISITION_LINE_ID = req_line_id
542: AND NVL(OOH.ORG_ID, -99) = NVL(PSP.ORG_ID, -99)

Line 1232: OE_ORDER_LINES_ALL OOL,

1228: FROM
1229: PO_REQUISITION_HEADERS PRH,
1230: PO_REQUISITION_LINES_ALL PRL,
1231: OE_ORDER_HEADERS_ALL OOH,
1232: OE_ORDER_LINES_ALL OOL,
1233: PO_SYSTEM_PARAMETERS PSP
1234: WHERE
1235: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1236: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND

Line 1323: OE_ORDER_LINES_ALL OOL,

1319: FROM
1320: PO_REQUISITION_HEADERS PRH,
1321: PO_REQUISITION_LINES_ALL PRL,
1322: OE_ORDER_HEADERS_ALL OOH,
1323: OE_ORDER_LINES_ALL OOL,
1324: PO_SYSTEM_PARAMETERS PSP
1325: WHERE
1326: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1327: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND