APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 711: FROM mtl_item_locations_kfv

707:
708: -- verify if locator is active
709: SELECT COUNT(*)
710: INTO l_loc_active
711: FROM mtl_item_locations_kfv
712: WHERE Nvl(disable_date, sysdate+1) > sysdate
713: AND organization_id = p_org_id
714: AND subinventory_code = l_sub
715: AND inventory_location_id = l_loc_id;

Line 2854: FROM mtl_item_locations_kfv

2850: l_loc_discrepancy_flag := 1;
2851:
2852: SELECT 1 INTO l_count FROM DUAL WHERE exists
2853: ( SELECT 1
2854: FROM mtl_item_locations_kfv
2855: WHERE organization_id = l_rec.organization_id
2856: AND inventory_location_id = l_rec.transfer_loc_id
2857: AND sysdate < nvl(disable_date,sysdate+1)
2858: );