APPS.IGR_IMP_003 dependencies on MTL_CATEGORIES_V

Line 1122: MTL_CATEGORIES_V C

1118: cp_product_category_set_id igr_i_lines_int.product_category_set_id%TYPE) IS
1119: SELECT 'X'
1120: FROM ENI_PROD_DENORM_HRCHY_V EPDHV,
1121: ENI_PROD_DEN_HRCHY_PARENTS_V P,
1122: MTL_CATEGORIES_V C
1123: WHERE P.CATEGORY_ID = EPDHV.CHILD_ID
1124: AND EPDHV.PARENT_ID = C.CATEGORY_ID
1125: AND C.DESCRIPTION = 'OSS Academic Interest'
1126: AND EPDHV.PARENT_ID <> P.CATEGORY_ID