APPS.EDW_ITEMS_M_C dependencies on MTL_CATEGORY_SETS_TL

Line 713: MTL_CATEGORY_SETS_TL tl

709: SET CATSET_CATEGORY_FK =
710: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(1)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
711: FROM
712: MTL_ITEM_CATEGORIES cat,
713: MTL_CATEGORY_SETS_TL tl
714: WHERE cat.organization_id = prod_family_fk_key
715: AND cat.inventory_item_id = catset_category_fk_key
716: AND tl.category_set_name = l_itemorg_catset1_name
717: AND cat.category_set_id = tl.category_set_id

Line 723: MTL_CATEGORY_SETS_TL tl

719: PROD_FAMILY_FK =
720: (SELECT DECODE(count(cat.category_id), 1, max(cat.category_id) || '-' || l_instance, 'NA_EDW')
721: FROM
722: MTL_ITEM_CATEGORIES cat,
723: MTL_CATEGORY_SETS_TL tl
724: WHERE cat.organization_id = prod_family_fk_key
725: AND cat.inventory_item_id = catset_category_fk_key
726: AND tl.category_set_name = 'Product Family'
727: AND cat.category_set_id = tl.category_set_id

Line 1134: MTL_CATEGORY_SETS_TL SETS

1130: MIC.INVENTORY_ITEM_ID,
1131: MIC.ORGANIZATION_ID
1132: FROM
1133: MTL_ITEM_CATEGORIES MIC,
1134: MTL_CATEGORY_SETS_TL SETS
1135: WHERE MIC.CATEGORY_SET_ID = SETS.CATEGORY_SET_ID
1136: AND MIC.LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date
1137: AND SETS.LANGUAGE = userenv('LANG')
1138: AND SETS.CATEGORY_SET_NAME IN (l_item_catset1_name,

Line 1320: MTL_CATEGORY_SETS_TL SETS

1316: MIC.INVENTORY_ITEM_ID,
1317: MIC.ORGANIZATION_ID
1318: FROM
1319: MTL_ITEM_CATEGORIES MIC,
1320: MTL_CATEGORY_SETS_TL SETS
1321: WHERE MIC.CATEGORY_SET_ID = SETS.CATEGORY_SET_ID
1322: AND MIC.LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date
1323: AND SETS.LANGUAGE = userenv('LANG')
1324: AND SETS.CATEGORY_SET_NAME IN (l_item_catset1_name,

Line 2868: MTL_CATEGORY_SETS_TL tl

2864: AND EXISTS /* Bug# 2559696 Removed the use of EDW_ITEMS_CATEGORY_FKV by dsakalle */
2865: (SELECT NULL
2866: FROM
2867: MTL_ITEM_CATEGORIES cat,
2868: MTL_CATEGORY_SETS_TL tl
2869: WHERE tl.CATEGORY_SET_NAME = l_item_catset3_name
2870: AND cat.CATEGORY_ID = LCV.CATEGORY_ID
2871: AND cat.CATEGORY_SET_ID = tl.CATEGORY_SET_ID);
2872:

Line 3046: MTL_CATEGORY_SETS_TL tl

3042: AND EXISTS /* Bug# 2559696 Removed the use of EDW_ITEMS_CATEGORY_FKV by dsakalle */
3043: (SELECT NULL
3044: FROM
3045: MTL_ITEM_CATEGORIES cat,
3046: MTL_CATEGORY_SETS_TL tl
3047: WHERE tl.CATEGORY_SET_NAME = l_item_catset3_name
3048: AND cat.CATEGORY_ID = LCV.CATEGORY_ID
3049: AND cat.CATEGORY_SET_ID = tl.CATEGORY_SET_ID);
3050: