[Home] [Help]
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
9729: AND ool.line_id = p_source_line_id
9730: AND wdd.source_line_id = ool.line_id
9731: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) = p_source_header_id
9765: NVL(poll.promised_date, poll.need_by_date)) AS expected_receipt_date
9766: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9767: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9768: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9769: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll
9770: WHERE poll.po_header_id = p_source_header_id
9771: AND poll.line_location_id = p_source_line_id
9772: AND poll.po_header_id = wdd.source_header_id (+)
9773: AND poll.po_line_id = wdd.source_line_id (+)
9814: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9815: rcv_shipment_headers rsh, rcv_shipment_lines rsl,
9816: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9817: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9818: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll, wsh_carriers wc_rsh
9819: WHERE rsl.po_header_id = p_source_header_id
9820: AND rsl.po_line_location_id = p_source_line_id
9821: AND rsl.shipment_line_id = p_source_line_detail_id
9822: AND poll.po_header_id = rsl.po_header_id
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
9885: WHERE prl.requisition_header_id = p_source_header_id
9886: AND prl.requisition_line_id = p_source_line_id
9887: AND prl.source_type_code = 'INVENTORY'
9888: AND NVL(prl.cancel_flag, 'N') = 'N'
9927: NVL(rsh.expected_receipt_date,
9928: NVL(rsh.shipped_date + NVL(mism.intransit_time, 0),
9929: rsh.shipped_date)) AS expected_receipt_date
9930: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh,
9931: wsh_carriers wc_rsh, mtl_interorg_ship_methods mism
9932: WHERE rsl.shipment_header_id = p_source_header_id
9933: AND rsl.shipment_line_id = p_source_line_id
9934: AND rsl.shipment_header_id = rsh.shipment_header_id
9935: AND rsh.shipment_num IS NOT NULL
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'
10503: AND wnd.delivery_id = wda.delivery_id (+)
10504: AND wda.delivery_detail_id = wdd.delivery_detail_id (+)