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 80: FROM oe_order_headers_all h,

76: -- { Start
77: -- 8555888
78: SELECT h.header_id
79: INTO l_header_id
80: FROM oe_order_headers_all h,
81: oe_order_lines_all l
82: WHERE h.order_source_id = nvl(p_order_source_id,10)
83: AND h.header_id=l.header_id
84: AND l.source_document_line_id = p_orig_sys_line_ref --bug 9233983

Line 177: FROM oe_order_headers_all h,

173: -- { Start
174: --8555888
175: SELECT h.header_id
176: INTO l_header_id
177: FROM oe_order_headers_all h,
178: oe_order_lines_all l
179: WHERE h.order_source_id = nvl(p_order_source_id,10)
180: AND h.header_id=l.header_id
181: AND l.source_document_line_id = p_orig_sys_line_ref --bug 9233983

Line 202: FROM oe_order_headers_all h, oe_order_lines_all l

198: /* Commented as part of above fix
199: SELECT nvl(l.shipped_quantity,0)
200: INTO x_shipped_qty
201: -- Following is changed to _all tables because of change in PO to multi-org
202: FROM oe_order_headers_all h, oe_order_lines_all l
203: -- Following is changed to _all tables because of change in PO to multi-org
204: WHERE h.order_source_id = nvl(p_order_source_id,10)
205: --AND h.source_document_id = p_orig_sys_document_ref
206: AND h.orig_sys_document_ref = l_orig_sys_document_ref

Line 302: FROM oe_order_headers_all h,

298: -- { Start
299: -- 8555888
300: SELECT h.header_id
301: INTO l_header_id
302: FROM oe_order_headers_all h,
303: oe_order_lines_all l
304: WHERE h.order_source_id = nvl(p_order_source_id,10)
305: AND h.header_id=l.header_id
306: AND l.source_document_line_id = p_orig_sys_line_ref --bug 9233983

Line 401: FROM oe_order_headers_all h,oe_order_lines_all l

397: -- Fix 7031428, added distinct for split lines from partial shipment
398:
399: SELECT distinct h.order_number
400: INTO x_order_number
401: FROM oe_order_headers_all h,oe_order_lines_all l
402: WHERE h.order_source_id = nvl(p_order_source_id,10)
403: AND h.orig_sys_document_ref = l_orig_sys_document_ref
404: AND h.header_id=l.header_id
405: AND h.source_document_id = to_number(p_orig_sys_document_ref)

Line 478: FROM oe_order_headers_all h,

474: AND rownum = 1;
475:
476: SELECT h.header_id
477: INTO x_header_id
478: FROM oe_order_headers_all h,
479: oe_order_lines_all l
480: WHERE h.order_source_id = nvl(p_order_source_id,10)
481: AND h.header_id=l.header_id
482: AND l.source_document_line_id = p_requisition_line_id

Line 554: FROM oe_order_headers_all

550: -- AND h.orig_sys_document_ref = r.segment1;
551:
552: SELECT source_document_id
553: INTO x_req_header_id
554: FROM oe_order_headers_all
555: WHERE header_id = p_header_id;
556: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
557: SELECT max(d.requisition_header_id)
558: INTO x_req_header_id

Line 626: FROM oe_order_headers_all h,

622: -- for bug 8555888
623:
624: SELECT h.header_id
625: INTO l_header_id
626: FROM oe_order_headers_all h,
627: oe_order_lines_all l
628: WHERE h.order_source_id = p_order_source_id
629: AND h.header_id=l.header_id
630: AND l.source_document_line_id = p_requisition_line_id