eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_ITEMS_M_C dependencies on MTL_ITEM_CATEGORIES

Line 400: MTL_ITEM_CATEGORIES MIC,

396: MIC.INVENTORY_ITEM_ID,
397: MIC.ORGANIZATION_ID
398: FROM
399: MTL_CATEGORIES CAT,
400: MTL_ITEM_CATEGORIES MIC,
401: MTL_CATEGORY_SETS SETS
402: WHERE CAT.CATEGORY_ID = MIC.CATEGORY_ID
403: AND MIC.CATEGORY_SET_ID = SETS.CATEGORY_SET_ID
404: AND MIC.LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date

Line 712: MTL_ITEM_CATEGORIES cat,

708: UPDATE EDW_ITEM_ITEMORG_TEMP
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

Line 722: MTL_ITEM_CATEGORIES cat,

718: AND tl.language = userenv('LANG')),
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'

Line 1133: MTL_ITEM_CATEGORIES MIC,

1129: SELECT
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')

Line 1142: MTL_ITEM_CATEGORIES MIC,

1138: AND SETS.CATEGORY_SET_NAME IN (l_item_catset1_name,
1139: l_item_catset2_name,
1140: l_item_catset3_name);
1141: MTL_CATEGORIES CAT,
1142: MTL_ITEM_CATEGORIES MIC,
1143: MTL_CATEGORY_SETS SETS
1144: WHERE CAT.CATEGORY_ID = MIC.CATEGORY_ID
1145: AND MIC.CATEGORY_SET_ID = SETS.CATEGORY_SET_ID
1146: AND MIC.LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date

Line 1319: MTL_ITEM_CATEGORIES MIC,

1315: SELECT
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')

Line 1348: MTL_ITEM_CATEGORIES cat,

1344: UPDATE EDW_ITEM_ITEM_TEMP
1345: SET CATSET1_CATEGORY_FK =
1346: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(2)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
1347: FROM
1348: MTL_ITEM_CATEGORIES cat,
1349: MTL_CATEGORY_SETS sets
1350: WHERE cat.organization_id = product_group_fk_key
1351: AND cat.inventory_item_id = catset1_category_fk_key
1352: -- AND sets.control_level = 1 Bug : 3720586

Line 1358: MTL_ITEM_CATEGORIES cat,

1354: AND cat.category_set_id = sets.category_set_id),
1355: CATSET2_CATEGORY_FK =
1356: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(2)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
1357: FROM
1358: MTL_ITEM_CATEGORIES cat,
1359: MTL_CATEGORY_SETS sets
1360: WHERE cat.organization_id = product_group_fk_key
1361: AND cat.inventory_item_id = catset1_category_fk_key
1362: AND sets.control_level = 1

Line 1376: MTL_ITEM_CATEGORIES cat,

1372: UPDATE EDW_ITEM_ITEM_TEMP
1373: SET CATSET1_CATEGORY_FK =
1374: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(2)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
1375: FROM
1376: MTL_ITEM_CATEGORIES cat,
1377: MTL_CATEGORY_SETS sets
1378: WHERE cat.organization_id = product_group_fk_key
1379: AND cat.inventory_item_id = catset1_category_fk_key
1380: -- AND sets.control_level = 1 Bug : 3720586

Line 1386: MTL_ITEM_CATEGORIES cat,

1382: AND cat.category_set_id = sets.category_set_id),
1383: CATSET2_CATEGORY_FK =
1384: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(2)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
1385: FROM
1386: MTL_ITEM_CATEGORIES cat,
1387: MTL_CATEGORY_SETS sets
1388: WHERE cat.organization_id = product_group_fk_key
1389: AND cat.inventory_item_id = catset1_category_fk_key
1390: AND sets.control_level = 1

Line 1396: MTL_ITEM_CATEGORIES cat,

1392: AND cat.category_set_id = sets.category_set_id),
1393: CATSET3_CATEGORY_FK =
1394: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(2)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
1395: FROM
1396: MTL_ITEM_CATEGORIES cat,
1397: MTL_CATEGORY_SETS sets
1398: WHERE cat.organization_id = product_group_fk_key
1399: AND cat.inventory_item_id = catset1_category_fk_key
1400: AND sets.control_level = 1

Line 2867: MTL_ITEM_CATEGORIES cat,

2863: AND LSTG.COLLECTION_STATUS = 'READY')
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);

Line 3045: MTL_ITEM_CATEGORIES cat,

3041: AND LSTG.COLLECTION_STATUS = 'READY')
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);