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_LINES_ALL

Line 87: FROM oe_order_lines_all l

83: AND NVL(h.org_id,-1) = l_org_id;
84:
85: Select sum(nvl(l.ordered_quantity, 0))
86: INTO x_open_qty
87: FROM oe_order_lines_all l
88: WHERE l.header_id = l_header_id
89: AND l.source_document_id = to_number(p_orig_sys_document_ref)
90: AND l.source_document_line_id = to_number(p_orig_sys_line_ref)
91: AND l.shipped_quantity IS NULL

Line 179: FROM oe_order_lines_all l

175: AND h.org_id = l_org_id;
176:
177: Select sum(nvl(l.shipped_quantity,0))
178: INTO x_shipped_qty
179: FROM oe_order_lines_all l
180: WHERE l.header_id = l_header_id
181: AND l.source_document_id = to_number(p_orig_sys_document_ref)
182: AND l.source_document_line_id = to_number(p_orig_sys_line_ref)
183: AND l.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 253: FROM oe_order_lines_all l

249: Cursor Cancelled_Qty_Cur Is
250: Select sum(l.cancelled_quantity) cancelled_quantity,
251: sum( l.shipped_quantity) shipped_quantity,
252: sum(l.ordered_quantity) ordered_quantity
253: FROM oe_order_lines_all l
254: WHERE l.header_id = l_header_id
255: AND l.source_document_id = to_number(p_orig_sys_document_ref)
256: AND l.source_document_line_id = to_number(p_orig_sys_line_ref)
257: AND l.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 586: FROM oe_order_lines_all l

582: l_line_id NUMBER;
583: l_line_id_count NUMBER := 0;
584: Cursor Line_Id_Cur Is
585: Select line_id
586: FROM oe_order_lines_all l
587: WHERE l.header_id = l_header_id
588: AND l.source_document_id = p_requisition_header_id
589: AND l.source_document_line_id = p_requisition_line_id
590: AND l.order_source_id = p_order_source_id