DBA Data[Home] [Help]

APPS.INV_COPY_ITEM_CP dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 998: FROM mtl_default_category_sets mdc

994: AND mcs.category_set_id = mic.category_set_id
995: AND mcs.control_level = 2
996: AND mcs.category_set_id NOT IN
997: ( SELECT mdc.category_set_id
998: FROM mtl_default_category_sets mdc
999: WHERE mdc.functional_area_id = DECODE( msi.INVENTORY_ITEM_FLAG, 'Y', 1, 0 )
1000: OR mdc.functional_area_id = DECODE( msi.PURCHASING_ITEM_FLAG, 'Y', 2, 0 )
1001: OR mdc.functional_area_id = DECODE( msi.INTERNAL_ORDER_FLAG, 'Y', 2, 0 )
1002: OR mdc.functional_area_id = DECODE( msi.MRP_PLANNING_CODE, 6, 0, 3 )