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

Line 6249: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6245: wdd.requested_quantity_uom2 AS secondary_uom_code,
6246: wdd.project_id AS project_id,
6247: wdd.task_id AS task_id,
6248: NULL AS wip_supply_type
6249: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6250: WHERE wdd.organization_id = l_organization_id
6251: AND wdd.inventory_item_id = l_inventory_item_id
6252: AND wdd.released_status = 'R'
6253: AND wdd.source_code = 'OE'

Line 6283: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6279: wdd.requested_quantity_uom2 AS secondary_uom_code,
6280: wdd.project_id AS project_id,
6281: wdd.task_id AS task_id,
6282: NULL AS wip_supply_type
6283: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6284: WHERE wdd.organization_id = l_organization_id
6285: AND wdd.inventory_item_id = l_inventory_item_id
6286: AND wdd.released_status = 'B'
6287: AND wdd.source_code = 'OE'

Line 6317: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6313: wdd.requested_quantity_uom2 AS secondary_uom_code,
6314: wdd.project_id AS project_id,
6315: wdd.task_id AS task_id,
6316: NULL AS wip_supply_type
6317: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6318: WHERE wdd.organization_id = l_organization_id
6319: AND wdd.inventory_item_id = l_inventory_item_id
6320: AND wdd.released_status = 'R'
6321: AND wdd.source_code = 'OE'

Line 6351: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6347: wdd.requested_quantity_uom2 AS secondary_uom_code,
6348: wdd.project_id AS project_id,
6349: wdd.task_id AS task_id,
6350: NULL AS wip_supply_type
6351: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6352: WHERE wdd.organization_id = l_organization_id
6353: AND wdd.inventory_item_id = l_inventory_item_id
6354: AND wdd.released_status = 'B'
6355: AND wdd.source_code = 'OE'

Line 6587: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6583: CURSOR reserved_wdd_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6584: SELECT wdd.delivery_detail_id, wdd.requested_quantity, wdd.requested_quantity_uom,
6585: wdd.requested_quantity2, wdd.requested_quantity_uom2,
6586: wdd.released_status, wdd.project_id, wdd.task_id
6587: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6588: WHERE wdd.organization_id = l_organization_id
6589: AND wdd.inventory_item_id = l_inventory_item_id
6590: AND wdd.released_status IN ('R', 'B')
6591: AND wdd.source_code = 'OE'

Line 7157: FROM wip_lpn_completions wlc, oe_order_lines_all ool

7153: BEGIN
7154: SELECT DECODE(ool.source_document_type_id, 10, 8, 2),
7155: wlc.demand_source_header_id, wlc.demand_source_line
7156: INTO l_wip_demand_type_id, l_wip_demand_header_id, l_wip_demand_line_id
7157: FROM wip_lpn_completions wlc, oe_order_lines_all ool
7158: WHERE wlc.header_id = l_mol_rec.reference_id
7159: -- MOL reference_id is link to header_id in WIP LPN Flow Completions table
7160: AND wlc.wip_entity_id = l_supply_header_id
7161: AND wlc.lpn_id = l_mol_lpn_id

Line 9724: FROM wsh_delivery_details wdd, oe_order_lines_all ool,

9720: NVL(wc_ool.carrier_id, wcs_ool.carrier_id)))) AS carrier_id,
9721: NVL(wts.planned_departure_date,
9722: NVL(wdd.date_scheduled,
9723: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
9724: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
9725: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9726: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9727: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9728: WHERE wdd.delivery_detail_id = p_source_line_detail_id

Line 9880: oe_order_lines_all ool, wsh_delivery_details wdd,

9876: NVL(wts.planned_arrival_date,
9877: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
9878: prl.need_by_date)) AS expected_receipt_date
9879: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,
9880: oe_order_lines_all ool, wsh_delivery_details wdd,
9881: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9882: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9883: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool,
9884: wsh_carriers wc_ool, wsh_carriers wc_rsh, wsh_carrier_services wcs_prl

Line 10498: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,

10494: MAX(NVL(wts.planned_departure_date,
10495: NVL(wdd.date_scheduled,
10496: NVL(ool.schedule_ship_date, ool.promise_date)))) AS max_expected_ship_date
10497: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
10498: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,
10499: wsh_carrier_services wcs_wnd, wsh_carrier_services wcs_wdd,
10500: wsh_carrier_services wcs_ool, wsh_carriers wc_ool
10501: WHERE wnd.delivery_id = p_delivery_id
10502: AND wnd.shipment_direction = 'O'