APPS.INVIDIT2 dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 635: , mtl_default_category_sets_fk_v mdcs

631: mdcs.functional_area_id
632: , FUNCTIONAL_AREA_DESC, mcs.category_set_name
633: FROM
634: mtl_category_sets_vl mcs
635: , mtl_default_category_sets_fk_v mdcs
636: WHERE
637: mcs.category_set_id = mdcs.category_set_id
638: AND mcs.default_category_id IS NULL;
639:

Line 877: FROM mtl_default_category_sets d

873: p.master_organization_id = X_master_org_id
874: AND s.default_category_id IS NOT NULL --Bug: 2801594
875: AND s.category_set_id =
876: ( SELECT d.category_set_id
877: FROM mtl_default_category_sets d
878: WHERE
879: d.functional_area_id = DECODE( X_customer_order_flag, 'Y', 11, 0 )
880: OR d.functional_area_id = DECODE( X_internal_order_flag, 'Y', 11, 0 )
881: )

Line 958: FROM mtl_default_category_sets d

954: mtl_category_sets_b s
955: WHERE
956: s.category_set_id IN
957: ( SELECT d.category_set_id
958: FROM mtl_default_category_sets d
959: WHERE
960: d.functional_area_id = DECODE( X_inventory_item_flag, 'Y', 1, 0 )
961: OR d.functional_area_id = DECODE( X_purchasing_item_flag, 'Y', 2, 0 )
962: OR d.functional_area_id = DECODE( X_internal_order_flag, 'Y', 2, 0 )

Line 1192: FROM mtl_default_category_sets d

1188: p.master_organization_id = X_master_org_id
1189: AND s.default_category_id IS NOT NULL --Bug: 2801594
1190: AND s.category_set_id IN
1191: ( SELECT d.category_set_id
1192: FROM mtl_default_category_sets d
1193: WHERE
1194: d.functional_area_id = DECODE( X_inventory_item_flag, 'Y', 1, 0 )
1195: OR d.functional_area_id = DECODE( X_purchasing_item_flag, 'Y', 2, 0 )
1196: OR d.functional_area_id = DECODE( X_internal_order_flag, 'Y', 2, 0 )

Line 1388: FROM mtl_default_category_sets d

1384: AND s.category_set_id = c.category_set_id
1385: AND ( s.control_level = 1
1386: OR EXISTS
1387: ( SELECT 'x'
1388: FROM mtl_default_category_sets d
1389: WHERE
1390: d.category_set_id = s.category_set_id
1391: AND
1392: (d.functional_area_id = DECODE( X_inventory_item_flag, 'Y', 1, 0 )

Line 1552: from mtl_default_category_sets d

1548: X_org_id
1549: from mtl_category_sets_B s
1550: where s.category_set_id in
1551: (select d.category_set_id
1552: from mtl_default_category_sets d
1553: where d.functional_area_id = 5)
1554: and not exists
1555: ( select 'x'
1556: from mtl_item_categories c