DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 410: OE_ORDER_HEADERS_ALL OOH,

406: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
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

Line 444: OE_ORDER_HEADERS_ALL OOH,

440: select count(OOL.LINE_ID)
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

Line 465: OE_ORDER_HEADERS_ALL OOH,

461: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
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

Line 494: OE_ORDER_HEADERS_ALL OOH,

490: select to_char(OOH.ORDER_NUMBER), OOL.FLOW_STATUS_CODE, OOL.LINE_ID
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

Line 614: OE_ORDER_HEADERS_ALL OOH,

610: select to_char(OOH.ORDER_NUMBER), OOH.FLOW_STATUS_CODE, OOL.LINE_ID
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

Line 1354: OE_ORDER_HEADERS_ALL OOH,

1350: into no_of_so, req_line_id_so
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

Line 1445: OE_ORDER_HEADERS_ALL OOH,

1441: order_status
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