APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1230: FROM mtl_item_locations_kfv

1226:
1227: -- verify if locator is active
1228: SELECT COUNT(*)
1229: INTO l_loc_active
1230: FROM mtl_item_locations_kfv
1231: WHERE Nvl(disable_date, sysdate+1) > sysdate
1232: AND organization_id = p_org_id
1233: AND subinventory_code = l_sub
1234: AND inventory_location_id = l_loc_id;

Line 3399: FROM mtl_item_locations_kfv

3395: l_loc_discrepancy_flag := 1;
3396:
3397: SELECT 1 INTO l_count FROM DUAL WHERE exists
3398: ( SELECT 1
3399: FROM mtl_item_locations_kfv
3400: WHERE organization_id = l_rec.organization_id
3401: AND inventory_location_id = l_rec.transfer_loc_id
3402: AND sysdate < nvl(disable_date,sysdate+1)
3403: );