APPS.WMS_XDOCK_PEGGING_PUB dependencies on WSH_CARRIERS

Line 9922: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool

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
9925: AND wdd.source_line_id = ool.line_id
9926: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) = p_source_header_id

Line 9964: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll

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
9967: AND poll.po_header_id = wdd.source_header_id (+)
9968: AND poll.po_line_id = wdd.source_line_id (+)

Line 10013: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll, wsh_carriers wc_rsh

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
10016: AND rsl.shipment_line_id = p_source_line_detail_id
10017: AND poll.po_header_id = rsl.po_header_id

Line 10079: wsh_carriers wc_ool, wsh_carriers wc_rsh, wsh_carrier_services wcs_prl

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
10081: AND prl.requisition_line_id = p_source_line_id
10082: AND prl.source_type_code = 'INVENTORY'
10083: AND NVL(prl.cancel_flag, 'N') = 'N'

Line 10126: wsh_carriers wc_rsh, mtl_interorg_ship_methods mism

10122: NVL(rsh.expected_receipt_date,
10123: NVL(rsh.shipped_date + NVL(mism.intransit_time, 0),
10124: rsh.shipped_date)) AS expected_receipt_date
10125: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh,
10126: wsh_carriers wc_rsh, mtl_interorg_ship_methods mism
10127: WHERE rsl.shipment_header_id = p_source_header_id
10128: AND rsl.shipment_line_id = p_source_line_id
10129: AND rsl.shipment_header_id = rsh.shipment_header_id
10130: AND rsh.shipment_num IS NOT NULL

Line 10695: wsh_carrier_services wcs_ool, wsh_carriers wc_ool

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'
10698: AND wnd.delivery_id = wda.delivery_id (+)
10699: AND wda.delivery_detail_id = wdd.delivery_detail_id (+)