APPS.WSH_UTIL_CORE dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 3107: wsh_delivery_assignments_v wda

3103:
3104: CURSOR get_ship_codes IS
3105: SELECT wdd.shipment_priority_code ship_priority_code
3106: FROM wsh_delivery_details wdd,
3107: wsh_delivery_assignments_v wda
3108: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3109: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3110: AND wda.delivery_id = p_delivery_id
3111: AND wda.delivery_id is not null

Line 3118: wsh_delivery_assignments_v wda

3114:
3115: CURSOR get_ship_codes1(p_ship_code IN VARCHAR2) IS
3116: SELECT wdd.shipment_priority_code ship_priority_code
3117: FROM wsh_delivery_details wdd,
3118: wsh_delivery_assignments_v wda
3119: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3120: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3121: AND wda.delivery_id = p_delivery_id
3122: AND wda.delivery_id is not null

Line 3131: wsh_delivery_assignments_v wda

3127:
3128: CURSOR get_ship_codes2 IS
3129: SELECT wdd.shipment_priority_code ship_priority_code
3130: FROM wsh_delivery_details wdd,
3131: wsh_delivery_assignments_v wda
3132: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3133: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3134: AND wda.delivery_id = p_delivery_id
3135: AND wdd.container_flag = 'N'

Line 3972: FROM wsh_delivery_assignments_v wda,

3968: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||
3969: 'get_operatingUnit_id';
3970: CURSOR c_orgs (v_delivery_id NUMBER) IS
3971: SELECT wdd.org_id org_id , count(*) cnt
3972: FROM wsh_delivery_assignments_v wda,
3973: wsh_delivery_details wdd
3974: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3975: AND wda.delivery_id = v_delivery_id
3976: AND wdd.container_flag = 'N'

Line 7643: wsh_delivery_assignments_v wda

7639: -- Entity Type => Delivery Detail
7640: cursor c_get_detail_status( c_delivery_detail_id NUMBER) is
7641: select status_code
7642: from wsh_new_deliveries wnd,
7643: wsh_delivery_assignments_v wda
7644: where wnd.delivery_id (+) = wda.delivery_id
7645: and wda.delivery_detail_id = c_delivery_detail_id;
7646:
7647: -- Entity Type => LPN

Line 7652: wsh_delivery_assignments_v wda,

7648: -- Modified query for bug 4990527 as per WMS requirement
7649: cursor c_get_lpn_delivery_status( c_lpn_id NUMBER) is
7650: select distinct wnd.delivery_id, wnd.status_code
7651: from wsh_new_deliveries wnd,
7652: wsh_delivery_assignments_v wda,
7653: wsh_delivery_details wdd
7654: where wnd.delivery_id (+) = wda.delivery_id
7655: and wda.delivery_detail_id = wdd.delivery_detail_id
7656: --LPN Reuse project