APPS.WSH_PR_CRITERIA dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 582: wsh_delivery_assignments_v wda

578: wda.delivery_id,
579: wdd.last_update_date,
580: wdd.client_id -- LSP PROJECT:
581: FROM wsh_delivery_details wdd,
582: wsh_delivery_assignments_v wda
583: WHERE wdd.delivery_detail_id = v_del_detail_id
584: AND wda.delivery_detail_id = wdd.delivery_detail_id
585: AND wdd.date_scheduled IS NOT NULL
586: AND wdd.date_requested >= nvl(g_from_request_date, wdd.date_requested)

Line 920: FROM wsh_delivery_assignments_v WDA,

916:
917: -- cursor to get lines within a container
918: CURSOR get_inner_items (v_del_detail_id NUMBER) IS
919: SELECT WDD.DELIVERY_DETAIL_ID
920: FROM wsh_delivery_assignments_v WDA,
921: WSH_DELIVERY_DETAILS WDD
922: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
923: AND WDD.CONTAINER_FLAG = 'N'
924: AND WDA.DELIVERY_ASSIGNMENT_ID IN

Line 926: FROM wsh_delivery_assignments_v WDA1

922: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
923: AND WDD.CONTAINER_FLAG = 'N'
924: AND WDA.DELIVERY_ASSIGNMENT_ID IN
925: (SELECT WDA1.DELIVERY_ASSIGNMENT_ID
926: FROM wsh_delivery_assignments_v WDA1
927: START WITH WDA1.PARENT_DELIVERY_DETAIL_ID = v_del_detail_id
928: CONNECT BY PRIOR WDA1.DELIVERY_DETAIL_ID = WDA1.PARENT_DELIVERY_DETAIL_ID);
929:
930: -- Cursor to get lines within a batch.

Line 2063: 'u', ' wsh_delivery_assignments_v WDA,');

2059: --{
2060: Process_Buffer(p_print_flag,
2061: 'u', ' FROM WSH_DELIVERY_DETAILS WDD,');
2062: Process_Buffer(p_print_flag,
2063: 'u', ' wsh_delivery_assignments_v WDA,');
2064:
2065: -- Bug 2040002: Need WSH_NEW_DELIVERIES under following conditions only
2066: IF ((g_ship_method_code IS NOT NULL) OR
2067: (g_trip_id > 0) OR