APPS.AMS_DMSELECTION_PVT dependencies on MTL_ITEM_CATEGORIES

Line 2157: FROM MTL_ITEM_CATEGORIES ic

2153: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'
2154: and aa.ACT_PRODUCT_USED_BY_ID = p_model_id
2155: and ol.INVENTORY_ITEM_ID IN
2156: (SELECT DISTINCT ic.INVENTORY_ITEM_ID
2157: FROM MTL_ITEM_CATEGORIES ic
2158: WHERE ic.CATEGORY_ID = aa.CATEGORY_ID
2159: AND (ic.INVENTORY_ITEM_ID = aa.INVENTORY_ITEM_ID OR aa.INVENTORY_ITEM_ID IS NULL))
2160: --and (oh.ORG_ID = aa.ORGANIZATION_ID OR aa.ORGANIZATION_ID IS NULL)
2161: --and ol.ORG_ID = nvl(aa.ORGANIZATION_ID,ol.ORG_ID)

Line 2198: FROM MTL_ITEM_CATEGORIES ic

2194: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'
2195: and aa.ACT_PRODUCT_USED_BY_ID = p_model_id
2196: and ol.INVENTORY_ITEM_ID IN
2197: (SELECT DISTINCT ic.INVENTORY_ITEM_ID
2198: FROM MTL_ITEM_CATEGORIES ic
2199: WHERE ic.CATEGORY_ID = aa.CATEGORY_ID
2200: AND (ic.INVENTORY_ITEM_ID = aa.INVENTORY_ITEM_ID OR aa.INVENTORY_ITEM_ID IS NULL))
2201: --and (oh.ORG_ID = aa.ORGANIZATION_ID OR aa.ORGANIZATION_ID IS NULL)
2202: --and ol.ORG_ID = nvl(aa.ORGANIZATION_ID,ol.ORG_ID)

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'