APPS.AMS_DMSELECTION_PVT dependencies on MTL_ITEM_CATEGORIES_V
Line 3859: FROM mtl_system_items_kfv items, mtl_item_categories_v cats
3855: ;
3856:
3857: CURSOR c_valid_prod (p_cat_id IN NUMBER, p_prod_id IN NUMBER, p_org_id IN NUMBER, p_cat_set_id IN NUMBER) IS
3858: SELECT 1 3859: FROM mtl_system_items_kfv items, mtl_item_categories_v cats 3860: WHERE cats.category_id = p_cat_id
3861: AND cats.inventory_item_id = p_prod_id
3862: AND items.inventory_item_id = p_prod_id
3863: AND UPPER(items.INVENTORY_ITEM_STATUS_CODE) <> 'INACTIVE'