DBA Data[Home] [Help]

APPS.ENI_ITEMS_STAR_PKG dependencies on MTL_CATEGORY_SETS_B

Line 1137: FROM mtl_default_category_sets a, mtl_category_sets_b b

1133: begin
1134: -- Which category set does assignment belong in ?
1135:
1136: SELECT 'INV_CATEGORY' INTO which_category_set
1137: FROM mtl_default_category_sets a, mtl_category_sets_b b
1138: WHERE a.functional_area_id = 1
1139: AND a.category_set_id = b.category_set_id
1140: AND b.structure_id = p_structure_id;
1141:

Line 1148: from mtl_category_Sets_b

1144: begin
1145: l_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
1146:
1147: select 'VBH_CATEGORY' into which_category_set
1148: from mtl_category_Sets_b
1149: where structure_id = p_structure_id
1150: and category_Set_id = l_category_set_id;
1151: exception
1152: when no_data_found then

Line 1749: FROM mtl_category_sets_b

1745: WHERE b.object_type = 'CATEGORY_SET'
1746: AND b.object_id = l_vbh_category_set
1747: AND b.item_assgn_flag = 'N'
1748: AND b.child_id = (SELECT DEFAULT_CATEGORY_ID
1749: FROM mtl_category_sets_b
1750: WHERE category_set_id=l_vbh_category_set)
1751: AND EXISTS (SELECT NULL
1752: FROM mtl_item_categories C
1753: WHERE c.category_set_id = l_vbh_category_set