APPS.WSH_PO_CMG_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 649: wsh_delivery_assignments_v WDA,

645: WDD.latest_dropoff_date ldd,
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

Line 741: FROM wsh_delivery_assignments_v WDA,

737: SELECT
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

Line 1880: wsh_delivery_assignments_v wda,

1876: --HACMS }
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

Line 3403: wsh_delivery_assignments_v wda

3399: wda.delivery_id,
3400: wdd.last_update_date
3401: FROM
3402: wsh_delivery_details wdd,
3403: wsh_delivery_assignments_v wda
3404: WHERE
3405: wdd.source_header_id = NVL(p_header_id,wdd.source_header_id) AND
3406: wdd.delivery_detail_id = wda.delivery_detail_id AND
3407: wdd.source_line_id = p_line_id AND