646: WDD.last_update_Date
647: FROM
648: WSH_DELIVERY_DETAILS WDD,
649: wsh_delivery_assignments_v WDA,
650: WSH_NEW_DELIVERIES WND
651: WHERE
652: WDD.Delivery_Detail_id = WDA.Delivery_Detail_id AND
653: WDA.Delivery_id = WND.Delivery_id(+) AND
654: WDD.released_status = 'X' AND
738: WTS.STOP_ID,
739: WTS.planned_arrival_date Stop_date ,
740: WTS.STOP_LOCATION_ID
741: FROM wsh_delivery_assignments_v WDA,
742: WSH_NEW_DELIVERIES WND,
743: WSH_DELIVERY_LEGS WDG,
744: WSH_TRIP_STOPS WTS
745: WHERE wda.delivery_detail_id = p_dd_id AND
746: WDA.DELIVERY_ID = WND.DELIVERY_ID AND
1877: wdd.last_update_date
1878: from
1879: wsh_delivery_details wdd,
1880: wsh_delivery_assignments_v wda,
1881: wsh_new_deliveries wnd
1882: where wdd.released_status = 'X' and
1883: WDD.source_code = 'PO' AND
1884: WDD.source_header_id = p_header_id AND
1885: WDD.source_line_id = p_line_id AND