APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on PO_REQUISITION_HEADERS

Line 61: FROM po_requisition_headers_all

57: */
58:
59: SELECT segment1
60: INTO l_orig_sys_document_ref
61: FROM po_requisition_headers_all
62: WHERE requisition_header_id = to_number(p_orig_sys_document_ref);
63:
64: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
65: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)

Line 154: FROM po_requisition_headers_all

150: */
151:
152: SELECT segment1
153: INTO l_orig_sys_document_ref
154: FROM po_requisition_headers_all
155: WHERE requisition_header_id = to_number(p_orig_sys_document_ref);
156:
157: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
158: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)

Line 274: FROM po_requisition_headers_all

270: */
271:
272: SELECT segment1
273: INTO l_orig_sys_document_ref
274: FROM po_requisition_headers_all
275: WHERE requisition_header_id = to_number(p_orig_sys_document_ref);
276:
277: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
278: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)

Line 369: FROM po_requisition_headers_all

365: */
366:
367: SELECT segment1
368: INTO l_orig_sys_document_ref
369: FROM po_requisition_headers_all
370: WHERE requisition_header_id = to_number(p_orig_sys_document_ref);
371:
372: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
373: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)

Line 527: -- FROM oe_order_headers h, po_requisition_headers r

523: IF p_type = 'H' THEN /* From oe_order_headers */
524: -- Following change is made to support the multi-org PO functionality
525: -- SELECT r.requisition_header_id
526: -- INTO x_req_header_id
527: -- FROM oe_order_headers h, po_requisition_headers r
528: -- WHERE h.header_id = p_header_id
529: -- AND h.orig_sys_document_ref = r.segment1;
530:
531: SELECT source_document_id

Line 545: FROM so_headers h, po_requisition_headers r

541: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
542: IF p_type = 'H' THEN /* From oe_order_headers */
543: SELECT r.requisition_header_id
544: INTO x_req_header_id
545: FROM so_headers h, po_requisition_headers r
546: WHERE h.header_id = p_header_id
547: AND h.original_system_reference = r.segment1;
548: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
549: SELECT d.requisition_header_id