DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on PO_REQUISITION_HEADERS_ALL

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)