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 162: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id

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)
164: INTO l_orig_sys_line_ref, l_org_id
165: FROM po_requisition_lines_all rl,
166: org_organization_definitions org

Line 166: org_organization_definitions org

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

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

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)
289: INTO l_orig_sys_line_ref, l_org_id
290: FROM po_requisition_lines_all rl,
291: org_organization_definitions org

Line 291: org_organization_definitions org

287: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
288: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
289: INTO l_orig_sys_line_ref, l_org_id
290: FROM po_requisition_lines_all rl,
291: org_organization_definitions org
292: WHERE rl.requisition_line_id = to_number(p_orig_sys_line_ref)
293: AND rl.requisition_header_id = to_number(p_orig_sys_document_ref)
294: AND rl.source_organization_id = org.organization_id
295: AND rownum = 1;

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

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)
389: INTO l_orig_sys_line_ref, l_org_id
390: FROM po_requisition_lines_all rl,
391: org_organization_definitions org

Line 391: org_organization_definitions org

387: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
388: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
389: INTO l_orig_sys_line_ref, l_org_id
390: FROM po_requisition_lines_all rl,
391: org_organization_definitions org
392: WHERE rl.requisition_line_id = to_number(p_orig_sys_line_ref)
393: AND rl.requisition_header_id = to_number(p_orig_sys_document_ref)
394: AND rl.source_organization_id = org.organization_id
395: AND rownum = 1;

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

462: indexes on oe_order_headers and oe_order_lines are
463: used again
464: */
465:
466: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
467: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
468: INTO l_orig_sys_line_ref, l_org_id
469: FROM po_requisition_lines_all rl,
470: org_organization_definitions org

Line 470: org_organization_definitions org

466: -- Fix for bug 3217280 = Added table org_organization_definitions to get org_id
467: SELECT rl.LINE_NUM, nvl(org.operating_unit,-1)
468: INTO l_orig_sys_line_ref, l_org_id
469: FROM po_requisition_lines_all rl,
470: org_organization_definitions org
471: WHERE rl.requisition_line_id = p_requisition_line_id
472: AND rl.requisition_header_id = p_requisition_header_id
473: AND rl.source_organization_id = org.organization_id
474: AND rownum = 1;