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 159: FROM po_requisition_headers_all

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

Line 284: FROM po_requisition_headers_all

280: */
281:
282: SELECT segment1
283: INTO l_orig_sys_document_ref
284: FROM po_requisition_headers_all
285: WHERE requisition_header_id = to_number(p_orig_sys_document_ref);
286:
287: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
288: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)

Line 384: FROM po_requisition_headers_all

380: */
381:
382: SELECT segment1
383: INTO l_orig_sys_document_ref
384: FROM po_requisition_headers_all
385: WHERE requisition_header_id = to_number(p_orig_sys_document_ref);
386:
387: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
388: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)

Line 548: -- FROM oe_order_headers h, po_requisition_headers r

544: IF p_type = 'H' THEN /* From oe_order_headers */
545: -- Following change is made to support the multi-org PO functionality
546: -- SELECT r.requisition_header_id
547: -- INTO x_req_header_id
548: -- FROM oe_order_headers h, po_requisition_headers r
549: -- WHERE h.header_id = p_header_id
550: -- AND h.orig_sys_document_ref = r.segment1;
551:
552: SELECT source_document_id

Line 566: FROM so_headers h, po_requisition_headers r

562: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
563: IF p_type = 'H' THEN /* From oe_order_headers */
564: SELECT r.requisition_header_id
565: INTO x_req_header_id
566: FROM so_headers h, po_requisition_headers r
567: WHERE h.header_id = p_header_id
568: AND h.original_system_reference = r.segment1;
569: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
570: SELECT d.requisition_header_id