DBA Data[Home] [Help]

APPS.AMS_ACTPRODUCT_PVT dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 2236: ENI_PROD_DEN_HRCHY_PARENTS_V d

2232: FROM
2233: mtl_default_category_sets a ,
2234: mtl_category_sets_b b ,
2235: mtl_categories_v c ,
2236: ENI_PROD_DEN_HRCHY_PARENTS_V d
2237: WHERE
2238: a.functional_area_id in (7,11)
2239: AND a.category_set_id = b.category_set_id
2240: AND b.structure_id = c.structure_id

Line 2330: ENI_PROD_DEN_HRCHY_PARENTS_V d

2326: FROM
2327: mtl_default_category_sets a ,
2328: mtl_category_sets_b b ,
2329: mtl_categories_v c ,
2330: ENI_PROD_DEN_HRCHY_PARENTS_V d
2331: WHERE
2332: a.functional_area_id in (7,11)
2333: AND a.category_set_id = b.category_set_id
2334: AND b.structure_id = c.structure_id

Line 2595: from ENI_PROD_DEN_HRCHY_PARENTS_V

2591:
2592: CURSOR check_cat_exist_hrchy
2593: IS
2594: select 1
2595: from ENI_PROD_DEN_HRCHY_PARENTS_V
2596: where category_id = p_act_product_rec.category_id
2597: start with category_id in (select category_id
2598: from ams_act_products
2599: where arc_act_product_used_by = 'CAMP'

Line 2775: FROM ENI_PROD_DEN_HRCHY_PARENTS_V a

2771: RETURN NUMBER IS
2772:
2773: CURSOR get_cat_Set_id
2774: IS Select category_Set_id
2775: FROM ENI_PROD_DEN_HRCHY_PARENTS_V a
2776: WHERE rownum <2 ;
2777:
2778: l_cat_set_id NUMBER;
2779: