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 ORG_ORGANIZATION_DEFINITIONS

Line 64: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id

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)
66: INTO l_orig_sys_line_ref, l_org_id
67: FROM po_requisition_lines_all rl,
68: org_organization_definitions org

Line 68: org_organization_definitions org

64: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
65: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
66: INTO l_orig_sys_line_ref, l_org_id
67: FROM po_requisition_lines_all rl,
68: org_organization_definitions org
69: WHERE rl.requisition_line_id = to_number(p_orig_sys_line_ref)
70: AND rl.requisition_header_id = to_number(p_orig_sys_document_ref)
71: AND rl.source_organization_id = org.organization_id
72: AND rownum = 1;

Line 157: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id

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)
159: INTO l_orig_sys_line_ref, l_org_id
160: FROM po_requisition_lines_all rl,
161: org_organization_definitions org

Line 161: org_organization_definitions org

157: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
158: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
159: INTO l_orig_sys_line_ref, l_org_id
160: FROM po_requisition_lines_all rl,
161: org_organization_definitions org
162: WHERE rl.requisition_line_id = to_number(p_orig_sys_line_ref)
163: AND rl.requisition_header_id = to_number(p_orig_sys_document_ref)
164: AND rl.source_organization_id = org.organization_id
165: AND rownum = 1;

Line 277: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id

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)
279: INTO l_orig_sys_line_ref, l_org_id
280: FROM po_requisition_lines_all rl,
281: org_organization_definitions org

Line 281: org_organization_definitions org

277: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
278: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
279: INTO l_orig_sys_line_ref, l_org_id
280: FROM po_requisition_lines_all rl,
281: org_organization_definitions org
282: WHERE rl.requisition_line_id = to_number(p_orig_sys_line_ref)
283: AND rl.requisition_header_id = to_number(p_orig_sys_document_ref)
284: AND rl.source_organization_id = org.organization_id
285: AND rownum = 1;

Line 372: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id

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)
374: INTO l_orig_sys_line_ref, l_org_id
375: FROM po_requisition_lines_all rl,
376: org_organization_definitions org

Line 376: org_organization_definitions org

372: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
373: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
374: INTO l_orig_sys_line_ref, l_org_id
375: FROM po_requisition_lines_all rl,
376: org_organization_definitions org
377: WHERE rl.requisition_line_id = to_number(p_orig_sys_line_ref)
378: AND rl.requisition_header_id = to_number(p_orig_sys_document_ref)
379: AND rl.source_organization_id = org.organization_id
380: AND rownum = 1;

Line 450: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id

446: indexes on oe_order_headers and oe_order_lines are
447: used again
448: */
449:
450: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
451: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
452: INTO l_orig_sys_line_ref, l_org_id
453: FROM po_requisition_lines_all rl,
454: org_organization_definitions org

Line 454: org_organization_definitions org

450: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
451: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
452: INTO l_orig_sys_line_ref, l_org_id
453: FROM po_requisition_lines_all rl,
454: org_organization_definitions org
455: WHERE rl.requisition_line_id = p_requisition_line_id
456: AND rl.requisition_header_id = p_requisition_header_id
457: AND rl.source_organization_id = org.organization_id
458: AND rownum = 1;