eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 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)