DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on OE_ORDER_LINES_ALL

Line 411: OE_ORDER_LINES_ALL OOL,

407: INTO l_so_number, l_status_code, l_line_id
408: from PO_REQUISITION_LINES PRL,
409: PO_REQUISITION_HEADERS PRH,
410: OE_ORDER_HEADERS_ALL OOH,
411: OE_ORDER_LINES_ALL OOL,
412: PO_SYSTEM_PARAMETERS PSP
413: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
414: AND PRL.REQUISITION_LINE_ID = req_line_id
415: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 445: OE_ORDER_LINES_ALL OOL,

441: INTO l_split_line_num
442: from PO_REQUISITION_LINES PRL,
443: PO_REQUISITION_HEADERS PRH,
444: OE_ORDER_HEADERS_ALL OOH,
445: OE_ORDER_LINES_ALL OOL,
446: PO_SYSTEM_PARAMETERS PSP
447: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
448: AND PRL.REQUISITION_LINE_ID = req_line_id
449: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 466: OE_ORDER_LINES_ALL OOL,

462: INTO l_so_number, l_status_code, l_line_id
463: from PO_REQUISITION_LINES PRL,
464: PO_REQUISITION_HEADERS PRH,
465: OE_ORDER_HEADERS_ALL OOH,
466: OE_ORDER_LINES_ALL OOL,
467: PO_SYSTEM_PARAMETERS PSP
468: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
469: AND PRL.REQUISITION_LINE_ID = req_line_id
470: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 495: OE_ORDER_LINES_ALL OOL,

491: INTO l_so_number, l_status_code, l_line_id
492: from PO_REQUISITION_LINES PRL,
493: PO_REQUISITION_HEADERS PRH,
494: OE_ORDER_HEADERS_ALL OOH,
495: OE_ORDER_LINES_ALL OOL,
496: PO_SYSTEM_PARAMETERS PSP
497: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
498: AND PRL.REQUISITION_LINE_ID = req_line_id
499: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 615: OE_ORDER_LINES_ALL OOL,

611: INTO l_so_number, l_status_code, l_line_id
612: from PO_REQUISITION_LINES_ALL PRL,
613: PO_REQUISITION_HEADERS_ALL PRH,
614: OE_ORDER_HEADERS_ALL OOH,
615: OE_ORDER_LINES_ALL OOL,
616: PO_SYSTEM_PARAMETERS_ALL PSP
617: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
618: AND PRL.REQUISITION_LINE_ID = req_line_id
619: AND NVL(OOH.ORG_ID, -99) = NVL(PSP.ORG_ID, -99)

Line 1355: OE_ORDER_LINES_ALL OOL,

1351: FROM
1352: PO_REQUISITION_HEADERS PRH,
1353: PO_REQUISITION_LINES_ALL PRL,
1354: OE_ORDER_HEADERS_ALL OOH,
1355: OE_ORDER_LINES_ALL OOL,
1356: PO_SYSTEM_PARAMETERS PSP
1357: WHERE
1358: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1359: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND

Line 1446: OE_ORDER_LINES_ALL OOL,

1442: FROM
1443: PO_REQUISITION_HEADERS PRH,
1444: PO_REQUISITION_LINES_ALL PRL,
1445: OE_ORDER_HEADERS_ALL OOH,
1446: OE_ORDER_LINES_ALL OOL,
1447: PO_SYSTEM_PARAMETERS PSP
1448: WHERE
1449: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1450: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND