DBA Data[Home] [Help]

APPS.IGR_IMP_003 dependencies on ENI_PROD_DENORM_HRCHY_V

Line 1120: FROM ENI_PROD_DENORM_HRCHY_V EPDHV,

1116: /*Cursor to validate the Product Category Id and Product Category Set ID *****/
1117: CURSOR c_val_acad_int(cp_product_category_id igr_i_lines_int.product_category_id%TYPE,
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