APPS.WMS_TASK_DISPATCH_GEN dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 7979: FROM wsh_delivery_assignments_v wda

7975: lpn_pjm_prj_tsk_rec pjm_rectype;
7976:
7977: CURSOR others_in_mmtt_delivery_cursor(l_lpn_id IN NUMBER) IS
7978: SELECT wda.delivery_id
7979: FROM wsh_delivery_assignments_v wda
7980: , wsh_delivery_details wdd
7981: , mtl_material_transactions_temp mmtt
7982: WHERE mmtt.transfer_lpn_id = l_lpn_id
7983: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 8004: FROM wsh_delivery_assignments_v wda

8000: child_lpns_rec child_lpns_cursor%ROWTYPE;
8001:
8002: CURSOR current_delivery_cursor IS
8003: SELECT wda.delivery_id
8004: FROM wsh_delivery_assignments_v wda
8005: , wsh_delivery_details wdd
8006: , mtl_material_transactions_temp mmtt
8007: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
8008: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 8015: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

8011: AND mmtt.organization_id = p_organization_id;
8012:
8013: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
8014: SELECT wda.delivery_id
8015: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
8016: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
8017: AND wdd.lpn_id = l_lpn_id
8018: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
8019: AND wdd.organization_id = p_organization_id;

Line 11583: , wsh_delivery_assignments_v wda

11579: SELECT COUNT(wdd2.lpn_id)
11580: INTO l_shipped_wdd_count_in_lpn
11581: FROM wsh_delivery_details wdd1
11582: , wsh_delivery_details wdd2
11583: , wsh_delivery_assignments_v wda
11584: , wms_license_plate_numbers wlpn
11585: WHERE wdd1.released_status = 'C'
11586: AND wda.delivery_detail_id = wdd1.delivery_detail_id
11587: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id