APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1053: ,wsh_delivery_assignments_v wda

1049: wdd.requested_quantity,
1050: msik.concatenated_segments,
1051: msik.description
1052: from wsh_delivery_details_ob_grp_v wdd
1053: ,wsh_delivery_assignments_v wda
1054: ,wsh_new_deliveries_ob_grp_v wnd
1055: ,mtl_system_items_kfv msik
1056: where wnd.delivery_id = p_delivery_id
1057: AND wnd.delivery_id = wda.delivery_id

Line 2904: FROM wsh_delivery_assignments_v

2900: , p_relieve_rsv IN VARCHAR2 DEFAULT 'Y'/*added 3396821*/
2901: ) IS
2902: CURSOR wda_del_detail(l_outermost_dd_id NUMBER) IS
2903: SELECT delivery_detail_id
2904: FROM wsh_delivery_assignments_v
2905: START WITH delivery_detail_id = l_outermost_dd_id
2906: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
2907:
2908: CURSOR wdd_del_detail(p_delivery_detail_id IN NUMBER) IS

Line 7569: FROM wsh_delivery_assignments_v wda

7565: --make sure delivery is assigned to the LPNs
7566: --Any of the LPN will do since they should be assigned to the same delivery
7567: SELECT wda.delivery_id
7568: INTO l_delivery_id
7569: FROM wsh_delivery_assignments_v wda
7570: WHERE wda.delivery_detail_id = l_par_del_det_tab(1)
7571: AND wda.delivery_id IS NOT NULL;
7572:
7573: DEBUG('Unpack delivery_id is: ' || l_delivery_id, 'Container_Nesting');

Line 7829: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

7825: AND released_status = 'X'; -- For LPN reuse ER : 6845650
7826:
7827: SELECT COUNT(*)
7828: INTO l_count_del_assign
7829: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
7830: WHERE wda.parent_delivery_detail_id = l_par_del_det_id
7831: AND wda.delivery_detail_id = wdd.delivery_detail_id
7832: AND NVL(wdd.container_flag, 'N') = 'N';
7833:

Line 7908: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik

7904: x_return_status := fnd_api.g_ret_sts_success;
7905:
7906: SELECT COUNT(*)
7907: INTO l_count
7908: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
7909: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7910: AND NVL(wdd.container_flag, 'N') = 'N'
7911: AND wda.delivery_id = p_delivery_id
7912: AND wdd.inventory_item_id = msik.inventory_item_id

Line 7960: FROM wsh_delivery_assignments_v

7956: AND direct_ship_flag = 'Y');
7957:
7958: CURSOR del_detail IS
7959: SELECT parent_delivery_detail_id
7960: FROM wsh_delivery_assignments_v
7961: WHERE delivery_id = p_delivery_id
7962: AND delivery_detail_id NOT IN(SELECT delivery_detail_id
7963: FROM wsh_delivery_details_ob_grp_v
7964: WHERE lpn_id IN(SELECT parent_lpn_id

Line 8004: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

8000: INTO l_num
8001: FROM DUAL
8002: WHERE EXISTS(
8003: SELECT 1
8004: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
8005: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
8006: AND wda.delivery_id = p_delivery_id
8007: AND wdd.released_status = 'Y'
8008: AND NVL(container_flag, 'N') = 'N'

Line 10371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

10367: FUNCTION validate_del_for_ds(p_lpn_id IN NUMBER, p_org_id IN NUMBER, p_dock_door_id IN NUMBER, p_header_id IN NUMBER, p_line_id IN NUMBER)
10368: RETURN BOOLEAN IS
10369: CURSOR del_cur IS
10370: SELECT wda.delivery_id
10371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
10372: WHERE wds.organization_id = p_org_id
10373: AND wds.dock_door_id = p_dock_door_id
10374: AND wds.lpn_id = p_lpn_id
10375: AND wds.order_header_id = p_header_id