DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_ITEM_CATEGORIES

Line 348: FROM MTL_ITEM_CATEGORIES mic

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

Line 1477: from mtl_item_categories mic

1473:
1474: select 'Y' INTO l_category_exist FROM dual
1475: where exists
1476: (select mic.category_id
1477: from mtl_item_categories mic
1478: where mic.organization_id = p_org_id
1479: and mic.inventory_item_id = p_inventory_item_id
1480: and mic.category_set_id = p_category_set_id
1481: and mic.category_id = p_category_id);