APPS.ENI_ITEMS_STAR_PKG dependencies on MTL_CATEGORY_SETS_B

Line 1317: FROM mtl_default_category_sets a, mtl_category_sets_b b

1313: begin
1314: -- Which category set does assignment belong in ?
1315:
1316: SELECT 'INV_CATEGORY' INTO which_category_set
1317: FROM mtl_default_category_sets a, mtl_category_sets_b b
1318: WHERE a.functional_area_id = 1
1319: AND a.category_set_id = b.category_set_id
1320: AND b.structure_id = p_structure_id;
1321:

Line 1328: from mtl_category_Sets_b

1324: begin
1325: l_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
1326:
1327: select 'VBH_CATEGORY' into which_category_set
1328: from mtl_category_Sets_b
1329: where structure_id = p_structure_id
1330: and category_Set_id = l_category_set_id;
1331: exception
1332: when no_data_found then

Line 1933: FROM mtl_category_sets_b

1929: WHERE b.object_type = 'CATEGORY_SET'
1930: AND b.object_id = l_vbh_category_set
1931: AND b.item_assgn_flag = 'N'
1932: AND b.child_id = (SELECT DEFAULT_CATEGORY_ID
1933: FROM mtl_category_sets_b
1934: WHERE category_set_id=l_vbh_category_set)
1935: AND EXISTS (SELECT NULL
1936: FROM mtl_item_categories C
1937: WHERE c.category_set_id = l_vbh_category_set