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 WSH_NEW_DELIVERIES

Line 9920: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

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
9924: AND ool.line_id = p_source_line_id

Line 9962: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

9958: wc_poll.carrier_id))) AS carrier_id,
9959: NVL(wts.planned_arrival_date,
9960: NVL(poll.promised_date, poll.need_by_date)) AS expected_receipt_date
9961: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9962: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9963: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9964: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll
9965: WHERE poll.po_header_id = p_source_header_id
9966: AND poll.line_location_id = p_source_line_id

Line 10011: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

10007: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
10008: NVL(poll.promised_date, poll.need_by_date))) AS expected_receipt_date
10009: FROM po_line_locations_all poll, wsh_delivery_details wdd,
10010: rcv_shipment_headers rsh, rcv_shipment_lines rsl,
10011: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
10012: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
10013: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll, wsh_carriers wc_rsh
10014: WHERE rsl.po_header_id = p_source_header_id
10015: AND rsl.po_line_location_id = p_source_line_id

Line 10076: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,

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
10080: WHERE prl.requisition_header_id = p_source_header_id

Line 10692: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

10688: NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
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