DBA Data[Home] [Help]

APPS.GRP_DISCOUNTS dependencies on MTL_ITEM_CATEGORIES

Line 12: ,MTL_ITEM_CATEGORIES MTC

8: SELECT 'Y'
9: FROM mtl_default_category_sets MTDCS
10: , mtl_category_set_valid_cats MCSV
11: , mtl_categories MC
12: ,MTL_ITEM_CATEGORIES MTC
13: WHERE MTDCS.functional_area_id = 7
14: AND MTC.category_set_id = MTDCS.category_set_id
15: AND MTC.INVENTORY_ITEM_ID = TO_CHAR( Inv_Item_Id )
16: AND MCSV.category_set_id = MTC.category_set_id

Line 28: , MTL_ITEM_CATEGORIES MTC

24: SELECT 'Y'
25: FROM mtl_default_category_sets MTDCS
26: , mtl_category_set_valid_cats MCSV
27: , mtl_categories MC
28: , MTL_ITEM_CATEGORIES MTC
29: WHERE MTDCS.functional_area_id = 7
30: AND MTC.category_set_id = MTDCS.category_set_id
31: AND MTC.INVENTORY_ITEM_ID = TO_CHAR( Inv_Item_Id )
32: AND MCSV.category_set_id = MTC.category_set_id