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.WSH_MAPPING_DATA dependencies on OE_ORDER_LINES_ALL

Line 1915: from oe_order_lines_all ol,

1911: -- Distributed - TPW Changes
1912: l_source_document_type_id,
1913: l_source_document_id,
1914: l_source_document_line_id
1915: from oe_order_lines_all ol,
1916: oe_order_headers_all oh,
1917: wsh_transactions_history wth
1918: where ol.line_id = p_src_line_id
1919: and ol.header_id = oh.header_id

Line 2029: oe_order_lines_all ol

2025: ol.ship_to_contact_id,
2026: ol.deliver_to_org_id,
2027: ol.deliver_to_contact_id
2028: FROM wsh_delivery_details wdd,
2029: oe_order_lines_all ol
2030: WHERE wdd.delivery_detail_id = c_detail_id
2031: AND wdd.source_line_id = ol.line_id
2032: AND wdd.source_code = 'OE'
2033: AND wdd.container_flag = 'N';

Line 2446: oe_order_lines_all ol

2442: ol.invoice_to_org_id
2443: FROM wsh_new_deliveries wnd,
2444: wsh_delivery_assignments_v wda,
2445: wsh_delivery_details wdd,
2446: oe_order_lines_all ol
2447: WHERE wnd.delivery_id = p_delivery_id
2448: AND wnd.delivery_id = wda.delivery_id
2449: AND wda.delivery_detail_id = wdd.delivery_detail_id
2450: AND wdd.source_code = 'OE'

Line 2604: oe_order_lines_all ol

2600: into l_ship_to_contact_id
2601: from wsh_new_deliveries wnd,
2602: wsh_delivery_assignments_v wda,
2603: wsh_delivery_details wdd,
2604: oe_order_lines_all ol
2605: where wnd.delivery_id = p_delivery_id
2606: and wnd.delivery_id = wda.delivery_id
2607: and wda.delivery_detail_id = wdd.delivery_detail_id
2608: and wdd.source_code = 'OE'

Line 2664: oe_order_lines_all ol

2660: into l_bill_to_contact_id
2661: from wsh_new_deliveries wnd,
2662: wsh_delivery_assignments_v wda,
2663: wsh_delivery_details wdd,
2664: oe_order_lines_all ol
2665: where wnd.delivery_id = p_delivery_id
2666: and wnd.delivery_id = wda.delivery_id
2667: and wda.delivery_detail_id = wdd.delivery_detail_id
2668: and wdd.source_code = 'OE'

Line 3221: from oe_order_lines_all ol,

3217: x_line_quantity,
3218: l_line_set_id,
3219: l_req_qty_uom,
3220: l_inv_item_id
3221: from oe_order_lines_all ol,
3222: mtl_system_items_kfv msik,
3223: oe_sets,
3224: mtl_customer_items
3225: where ol.line_id = p_reference_line_id

Line 3234: from oe_order_lines_all ol1

3230:
3231: if (l_line_set_id is not null) then
3232: select sum(ol1.ordered_quantity)
3233: into x_line_quantity
3234: from oe_order_lines_all ol1
3235: where ol1.line_set_id = l_line_set_id;
3236: end if;
3237:
3238: -- Bug 9234726: If Ordered UOM is different from Item's Primary UOM then