DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_ITEM_CATEGORIES

Line 349: FROM MTL_ITEM_CATEGORIES mic

345: ,MTL_CATEGORY_SETS_VL mcs
346: ,( SELECT mic.ORGANIZATION_ID
347: ,mic.CATEGORY_SET_ID
348: ,mic.CATEGORY_ID
349: FROM MTL_ITEM_CATEGORIES mic
350: WHERE mic.ORGANIZATION_ID = p_org_id
351: GROUP BY mic.ORGANIZATION_ID
352: ,mic.CATEGORY_SET_ID
353: ,mic.CATEGORY_ID ) x

Line 1691: from mtl_item_categories mic

1687: IF g_item_cat_table.EXISTS(l_hash_value) THEN
1688: l_category_exist :=g_item_cat_table(l_hash_value);
1689: ELSE
1690: select 'Y' INTO l_category_exist
1691: from mtl_item_categories mic
1692: where mic.organization_id = p_org_id
1693: and mic.inventory_item_id = p_inventory_item_id
1694: and mic.category_set_id = p_category_set_id
1695: and mic.category_id = p_category_id