DBA Data[Home] [Help]

APPS.WSH_PO_CMG_PVT dependencies on WSH_NEW_DELIVERIES

Line 650: WSH_NEW_DELIVERIES WND

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

Line 742: WSH_NEW_DELIVERIES WND,

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

Line 1881: wsh_new_deliveries wnd

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