DBA Data[Home] [Help]

APPS.QA_SS_CORE dependencies on MTL_ITEM_CATEGORIES

Line 167: from mtl_item_categories mic, mtl_categories_kfv mck

163:
164: CURSOR category_cur(p_org_id NUMBER, p_item_id NUMBER, p_category_set_id NUMBER) IS
165: select mck.concatenated_segments,
166: mck.category_id
167: from mtl_item_categories mic, mtl_categories_kfv mck
168: where mic.organization_id = p_org_id
169: and mic.category_id = mck.category_id
170: and mic.inventory_item_id =p_item_id
171: and mic.category_set_id = p_category_set_id;