APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1136: ,wsh_delivery_assignments_v wda

1132: wdd.requested_quantity,
1133: msik.concatenated_segments,
1134: msik.description
1135: from wsh_delivery_details_ob_grp_v wdd
1136: ,wsh_delivery_assignments_v wda
1137: ,wsh_new_deliveries_ob_grp_v wnd
1138: ,mtl_system_items_kfv msik
1139: where wnd.delivery_id = p_delivery_id
1140: AND wnd.delivery_id = wda.delivery_id

Line 3060: FROM wsh_delivery_assignments_v

3056: , p_relieve_rsv IN VARCHAR2 DEFAULT 'Y'/*added 3396821*/
3057: ) IS
3058: CURSOR wda_del_detail(l_outermost_dd_id NUMBER) IS
3059: SELECT delivery_detail_id
3060: FROM wsh_delivery_assignments_v
3061: START WITH delivery_detail_id = l_outermost_dd_id
3062: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
3063:
3064: CURSOR wdd_del_detail(p_delivery_detail_id IN NUMBER) IS

Line 8666: FROM wsh_delivery_assignments_v wda

8662: --make sure delivery is assigned to the LPNs
8663: --Any of the LPN will do since they should be assigned to the same delivery
8664: SELECT wda.delivery_id
8665: INTO l_delivery_id
8666: FROM wsh_delivery_assignments_v wda
8667: WHERE wda.delivery_detail_id = l_par_del_det_tab(1)
8668: AND wda.delivery_id IS NOT NULL;
8669:
8670: DEBUG('Unpack delivery_id is: ' || l_delivery_id, 'Container_Nesting');

Line 8926: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

8922: AND released_status = 'X'; -- For LPN reuse ER : 6845650
8923:
8924: SELECT COUNT(*)
8925: INTO l_count_del_assign
8926: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
8927: WHERE wda.parent_delivery_detail_id = l_par_del_det_id
8928: AND wda.delivery_detail_id = wdd.delivery_detail_id
8929: AND NVL(wdd.container_flag, 'N') = 'N';
8930:

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

9001: x_return_status := fnd_api.g_ret_sts_success;
9002:
9003: SELECT COUNT(*)
9004: INTO l_count
9005: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
9006: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
9007: AND NVL(wdd.container_flag, 'N') = 'N'
9008: AND wda.delivery_id = p_delivery_id
9009: AND wdd.inventory_item_id = msik.inventory_item_id

Line 9056: FROM wsh_delivery_assignments_v

9052: AND direct_ship_flag = 'Y');
9053:
9054: CURSOR del_detail IS
9055: SELECT parent_delivery_detail_id
9056: FROM wsh_delivery_assignments_v
9057: WHERE delivery_id = p_delivery_id
9058: AND delivery_detail_id NOT IN(SELECT delivery_detail_id
9059: FROM wsh_delivery_details_ob_grp_v
9060: WHERE lpn_id IN(SELECT parent_lpn_id

Line 9098: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

9094: INTO l_num
9095: FROM DUAL
9096: WHERE EXISTS(
9097: SELECT 1
9098: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
9099: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9100: AND wda.delivery_id = p_delivery_id
9101: AND wdd.released_status = 'Y'
9102: AND NVL(container_flag, 'N') = 'N'

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

12120: ) RETURN BOOLEAN IS
12121:
12122: CURSOR del_cur IS
12123: SELECT wda.delivery_id
12124: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
12125: WHERE wds.organization_id = p_org_id
12126: AND wds.dock_door_id = p_dock_door_id
12127: AND wds.lpn_id = p_lpn_id
12128: AND wds.order_header_id = p_header_id