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 OE_ORDER_HEADERS_ALL

Line 79: FROM oe_order_headers_all h

75: -- Fix for bug 2469894,2641565
76: -- { Start
77: SELECT h.header_id
78: INTO l_header_id
79: FROM oe_order_headers_all h
80: WHERE h.order_source_id = nvl(p_order_source_id,10)
81: AND h.orig_sys_document_ref = l_orig_sys_document_ref
82: AND h.source_document_id = to_number(p_orig_sys_document_ref)
83: AND NVL(h.org_id,-1) = l_org_id;

Line 171: FROM oe_order_headers_all h

167: -- Fix for bug 2469894
168: -- { Start
169: SELECT h.header_id
170: INTO l_header_id
171: FROM oe_order_headers_all h
172: WHERE h.order_source_id = nvl(p_order_source_id,10)
173: AND h.orig_sys_document_ref = l_orig_sys_document_ref
174: AND h.source_document_id = to_number(p_orig_sys_document_ref)
175: AND h.org_id = l_org_id;

Line 192: FROM oe_order_headers_all h, oe_order_lines_all l

188: /* Commented as part of above fix
189: SELECT nvl(l.shipped_quantity,0)
190: INTO x_shipped_qty
191: -- Following is changed to _all tables because of change in PO to multi-org
192: FROM oe_order_headers_all h, oe_order_lines_all l
193: -- Following is changed to _all tables because of change in PO to multi-org
194: WHERE h.order_source_id = nvl(p_order_source_id,10)
195: --AND h.source_document_id = p_orig_sys_document_ref
196: AND h.orig_sys_document_ref = l_orig_sys_document_ref

Line 291: FROM oe_order_headers_all h

287: -- Fix for bug 2469894,2641565
288: -- { Start
289: SELECT h.header_id
290: INTO l_header_id
291: FROM oe_order_headers_all h
292: WHERE h.order_source_id = nvl(p_order_source_id,10)
293: AND h.orig_sys_document_ref = l_orig_sys_document_ref
294: AND h.source_document_id = to_number(p_orig_sys_document_ref)
295: AND h.org_id = l_org_id;

Line 386: FROM oe_order_headers_all h,oe_order_lines_all l

382: -- Fix 7031428, added distinct for split lines from partial shipment
383:
384: SELECT distinct h.order_number
385: INTO x_order_number
386: FROM oe_order_headers_all h,oe_order_lines_all l
387: WHERE h.order_source_id = nvl(p_order_source_id,10)
388: AND h.orig_sys_document_ref = l_orig_sys_document_ref
389: AND h.source_document_id = to_number(p_orig_sys_document_ref)
390: AND l.orig_sys_document_ref = l_orig_sys_document_ref

Line 462: FROM oe_order_headers_all h

458: AND rownum = 1;
459:
460: SELECT h.header_id
461: INTO x_header_id
462: FROM oe_order_headers_all h
463: WHERE h.order_source_id = nvl(p_order_source_id,10)
464: AND h.orig_sys_document_ref = p_orig_sys_document_ref
465: AND h.source_document_id = p_requisition_header_id
466: AND nvl(h.org_id,-1) = l_org_id;--added nvl for bug5394855

Line 533: FROM oe_order_headers_all

529: -- AND h.orig_sys_document_ref = r.segment1;
530:
531: SELECT source_document_id
532: INTO x_req_header_id
533: FROM oe_order_headers_all
534: WHERE header_id = p_header_id;
535: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
536: SELECT max(d.requisition_header_id)
537: INTO x_req_header_id

Line 602: FROM oe_order_headers_all h

598:
599: x_return_status := fnd_api.g_ret_sts_success;
600: SELECT h.header_id
601: INTO l_header_id
602: FROM oe_order_headers_all h
603: WHERE h.order_source_id = p_order_source_id
604: AND h.orig_sys_document_ref = p_orig_sys_document_ref
605: AND h.source_document_id = p_requisition_header_id;
606: