APPS.WSH_PR_CRITERIA dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 560: wsh_delivery_assignments_v wda

556: wdd.ship_set_id,
557: wda.delivery_id,
558: wdd.last_update_date
559: FROM wsh_delivery_details wdd,
560: wsh_delivery_assignments_v wda
561: WHERE wdd.delivery_detail_id = v_del_detail_id
562: AND wda.delivery_detail_id = wdd.delivery_detail_id
563: AND wdd.date_scheduled IS NOT NULL
564: AND wdd.date_requested >= nvl(g_from_request_date, wdd.date_requested)

Line 888: FROM wsh_delivery_assignments_v WDA,

884:
885: -- cursor to get lines within a container
886: CURSOR get_inner_items (v_del_detail_id NUMBER) IS
887: SELECT WDD.DELIVERY_DETAIL_ID
888: FROM wsh_delivery_assignments_v WDA,
889: WSH_DELIVERY_DETAILS WDD
890: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
891: AND WDD.CONTAINER_FLAG = 'N'
892: AND WDA.DELIVERY_ASSIGNMENT_ID IN

Line 894: FROM wsh_delivery_assignments_v WDA1

890: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
891: AND WDD.CONTAINER_FLAG = 'N'
892: AND WDA.DELIVERY_ASSIGNMENT_ID IN
893: (SELECT WDA1.DELIVERY_ASSIGNMENT_ID
894: FROM wsh_delivery_assignments_v WDA1
895: START WITH WDA1.PARENT_DELIVERY_DETAIL_ID = v_del_detail_id
896: CONNECT BY PRIOR WDA1.DELIVERY_DETAIL_ID = WDA1.PARENT_DELIVERY_DETAIL_ID);
897:
898: -- Cursor to get lines within a batch.

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

1977: --{
1978: Process_Buffer(p_print_flag,
1979: 'u', ' FROM WSH_DELIVERY_DETAILS WDD,');
1980: Process_Buffer(p_print_flag,
1981: 'u', ' wsh_delivery_assignments_v WDA,');
1982:
1983: -- Bug 2040002: Need WSH_NEW_DELIVERIES under following conditions only
1984: IF ((g_ship_method_code IS NOT NULL) OR
1985: (g_trip_id > 0) OR