DBA Data[Home] [Help]

APPS.POA_CM_EVAL_SCORES_ICX dependencies on MTL_ITEM_CATEGORIES

Line 600: mtl_item_categories mic

596: if (l_item_id is null) and (l_item is not null) then
597: SELECT min(msi.inventory_item_id)
598: INTO l_item_id
599: FROM mtl_system_items_kfv msi,
600: mtl_item_categories mic
601: WHERE msi.CONCATENATED_SEGMENTS = l_item
602: AND msi.organization_id = x_organization_id
603: AND msi.inventory_item_id = mic.inventory_item_id
604: AND msi.organization_id = mic.organization_id

Line 621: FROM mtl_item_categories

617: if (l_category_id is null) and (l_item_id is not null) then
618:
619: SELECT CATEGORY_ID
620: INTO l_category_id
621: FROM mtl_item_categories
622: WHERE organization_id = x_organization_id
623: AND category_set_id = x_category_set_id
624: AND INVENTORY_ITEM_ID = l_item_id;
625: