APPS.POR_VIEW_REQS_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 334: OE_ORDER_HEADERS_ALL OOH,

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

Line 367: OE_ORDER_HEADERS_ALL OOH,

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

Line 388: OE_ORDER_HEADERS_ALL OOH,

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

Line 417: OE_ORDER_HEADERS_ALL OOH,

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

Line 537: OE_ORDER_HEADERS_ALL OOH,

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

Line 1231: OE_ORDER_HEADERS_ALL OOH,

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

Line 1322: OE_ORDER_HEADERS_ALL OOH,

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