DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2858: FROM mtl_item_locations_kfv

2854:
2855: -- verify if locator is active
2856: SELECT COUNT(*)
2857: INTO l_loc_active
2858: FROM mtl_item_locations_kfv
2859: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
2860: AND organization_id = p_org_id
2861: AND subinventory_code = l_sub
2862: AND inventory_location_id = l_loc_id;