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 6420: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6416: wdd.requested_quantity_uom2 AS secondary_uom_code,
6417: wdd.project_id AS project_id,
6418: wdd.task_id AS task_id,
6419: NULL AS wip_supply_type
6420: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6421: WHERE wdd.organization_id = l_organization_id
6422: AND wdd.inventory_item_id = l_inventory_item_id
6423: AND wdd.released_status = 'R'
6424: AND wdd.source_code = 'OE'

Line 6455: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6451: wdd.requested_quantity_uom2 AS secondary_uom_code,
6452: wdd.project_id AS project_id,
6453: wdd.task_id AS task_id,
6454: NULL AS wip_supply_type
6455: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6456: WHERE wdd.organization_id = l_organization_id
6457: AND wdd.inventory_item_id = l_inventory_item_id
6458: AND wdd.released_status = 'B'
6459: AND wdd.source_code = 'OE'

Line 6490: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6486: wdd.requested_quantity_uom2 AS secondary_uom_code,
6487: wdd.project_id AS project_id,
6488: wdd.task_id AS task_id,
6489: NULL AS wip_supply_type
6490: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6491: WHERE wdd.organization_id = l_organization_id
6492: AND wdd.inventory_item_id = l_inventory_item_id
6493: AND wdd.released_status = 'R'
6494: AND wdd.source_code = 'OE'

Line 6525: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6521: wdd.requested_quantity_uom2 AS secondary_uom_code,
6522: wdd.project_id AS project_id,
6523: wdd.task_id AS task_id,
6524: NULL AS wip_supply_type
6525: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6526: WHERE wdd.organization_id = l_organization_id
6527: AND wdd.inventory_item_id = l_inventory_item_id
6528: AND wdd.released_status = 'B'
6529: AND wdd.source_code = 'OE'

Line 6762: FROM wsh_delivery_details wdd, oe_order_lines_all ool

6758: CURSOR reserved_wdd_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6759: SELECT wdd.delivery_detail_id, wdd.requested_quantity, wdd.requested_quantity_uom,
6760: wdd.requested_quantity2, wdd.requested_quantity_uom2,
6761: wdd.released_status, wdd.project_id, wdd.task_id
6762: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6763: WHERE wdd.organization_id = l_organization_id
6764: AND wdd.inventory_item_id = l_inventory_item_id
6765: AND wdd.released_status IN ('R', 'B')
6766: AND wdd.source_code = 'OE'

Line 7332: FROM wip_lpn_completions wlc, oe_order_lines_all ool

7328: BEGIN
7329: SELECT DECODE(ool.source_document_type_id, 10, 8, 2),
7330: wlc.demand_source_header_id, wlc.demand_source_line
7331: INTO l_wip_demand_type_id, l_wip_demand_header_id, l_wip_demand_line_id
7332: FROM wip_lpn_completions wlc, oe_order_lines_all ool
7333: WHERE wlc.header_id = l_mol_rec.reference_id
7334: -- MOL reference_id is link to header_id in WIP LPN Flow Completions table
7335: AND wlc.wip_entity_id = l_supply_header_id
7336: AND wlc.lpn_id = l_mol_lpn_id

Line 9919: FROM wsh_delivery_details wdd, oe_order_lines_all ool,

9915: NVL(wc_ool.carrier_id, wcs_ool.carrier_id)))) AS carrier_id,
9916: NVL(wts.planned_departure_date,
9917: NVL(wdd.date_scheduled,
9918: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
9919: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
9920: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9921: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9922: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9923: WHERE wdd.delivery_detail_id = p_source_line_detail_id

Line 10075: oe_order_lines_all ool, wsh_delivery_details wdd,

10071: NVL(wts.planned_arrival_date,
10072: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
10073: prl.need_by_date)) AS expected_receipt_date
10074: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,
10075: oe_order_lines_all ool, wsh_delivery_details wdd,
10076: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
10077: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
10078: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool,
10079: wsh_carriers wc_ool, wsh_carriers wc_rsh, wsh_carrier_services wcs_prl

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

10689: MAX(NVL(wts.planned_departure_date,
10690: NVL(wdd.date_scheduled,
10691: NVL(ool.schedule_ship_date, ool.promise_date)))) AS max_expected_ship_date
10692: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
10693: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,
10694: wsh_carrier_services wcs_wnd, wsh_carrier_services wcs_wdd,
10695: wsh_carrier_services wcs_ool, wsh_carriers wc_ool
10696: WHERE wnd.delivery_id = p_delivery_id
10697: AND wnd.shipment_direction = 'O'