APPS.WSH_UTIL_CORE dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 3143: wsh_delivery_assignments_v wda

3139:
3140: CURSOR get_ship_codes IS
3141: SELECT wdd.shipment_priority_code ship_priority_code
3142: FROM wsh_delivery_details wdd,
3143: wsh_delivery_assignments_v wda
3144: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3145: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3146: AND wda.delivery_id = p_delivery_id
3147: AND wda.delivery_id is not null

Line 3154: wsh_delivery_assignments_v wda

3150:
3151: CURSOR get_ship_codes1(p_ship_code IN VARCHAR2) IS
3152: SELECT wdd.shipment_priority_code ship_priority_code
3153: FROM wsh_delivery_details wdd,
3154: wsh_delivery_assignments_v wda
3155: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3156: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3157: AND wda.delivery_id = p_delivery_id
3158: AND wda.delivery_id is not null

Line 3167: wsh_delivery_assignments_v wda

3163:
3164: CURSOR get_ship_codes2 IS
3165: SELECT wdd.shipment_priority_code ship_priority_code
3166: FROM wsh_delivery_details wdd,
3167: wsh_delivery_assignments_v wda
3168: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3169: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3170: AND wda.delivery_id = p_delivery_id
3171: AND wdd.container_flag = 'N'

Line 4008: FROM wsh_delivery_assignments_v wda,

4004: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||
4005: 'get_operatingUnit_id';
4006: CURSOR c_orgs (v_delivery_id NUMBER) IS
4007: SELECT wdd.org_id org_id , count(*) cnt
4008: FROM wsh_delivery_assignments_v wda,
4009: wsh_delivery_details wdd
4010: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4011: AND wda.delivery_id = v_delivery_id
4012: AND wdd.container_flag = 'N'

Line 7679: wsh_delivery_assignments_v wda

7675: -- Entity Type => Delivery Detail
7676: cursor c_get_detail_status( c_delivery_detail_id NUMBER) is
7677: select status_code
7678: from wsh_new_deliveries wnd,
7679: wsh_delivery_assignments_v wda
7680: where wnd.delivery_id (+) = wda.delivery_id
7681: and wda.delivery_detail_id = c_delivery_detail_id;
7682:
7683: -- Entity Type => LPN

Line 7688: wsh_delivery_assignments_v wda,

7684: -- Modified query for bug 4990527 as per WMS requirement
7685: cursor c_get_lpn_delivery_status( c_lpn_id NUMBER) is
7686: select distinct wnd.delivery_id, wnd.status_code
7687: from wsh_new_deliveries wnd,
7688: wsh_delivery_assignments_v wda,
7689: wsh_delivery_details wdd
7690: where wnd.delivery_id (+) = wda.delivery_id
7691: and wda.delivery_detail_id = wdd.delivery_detail_id
7692: --LPN Reuse project