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_CATEGORY_SETS

Line 44: FROM MTL_CATEGORY_SETS_VL

40: -- for Category Set3
41: IF l_itm_hrchy3_coll_type = 'V' THEN
42: SELECT CATEGORY_SET_NAME
43: INTO l_item_catset3_name
44: FROM MTL_CATEGORY_SETS_VL
45: WHERE CATEGORY_SET_ID = g_vbh_catset_id;
46: END IF;
47:
48: EXCEPTION WHEN OTHERS THEN

Line 61: FROM mtl_category_sets mcs,

57: edw_log.put_line('Getting functional area for ' || p_category_set_name);
58: IF p_category_set_name <> 'NA_EDW' THEN
59: SELECT mtd.functional_area_id
60: INTO l_functional_area_id
61: FROM mtl_category_sets mcs,
62: mtl_default_category_sets mtd
63: WHERE mcs.category_set_name = p_category_set_name
64: AND mcs.category_set_id = mtd.category_set_id;
65: END IF;

Line 401: MTL_CATEGORY_SETS SETS

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
405: AND SETS.CATEGORY_SET_NAME = l_itemorg_catset1_name;

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 1143: MTL_CATEGORY_SETS SETS

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
1147: 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 1349: MTL_CATEGORY_SETS sets

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
1353: AND sets.category_set_name = l_item_catset1_name

Line 1359: MTL_CATEGORY_SETS sets

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
1363: AND sets.category_set_name = l_item_catset2_name

Line 1377: MTL_CATEGORY_SETS sets

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
1381: AND sets.category_set_name = l_item_catset1_name

Line 1387: MTL_CATEGORY_SETS sets

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
1391: AND sets.category_set_name = l_item_catset2_name

Line 1397: MTL_CATEGORY_SETS sets

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
1401: AND sets.category_set_name = l_item_catset3_name

Line 1931: FROM MTL_CATEGORY_SETS_VL

1927: WHERE APPLICATION_ID = '401'
1928: AND ID_FLEX_CODE = 'MCAT'
1929: AND ID_FLEX_NUM =
1930: (SELECT STRUCTURE_ID
1931: FROM MTL_CATEGORY_SETS_VL
1932: WHERE CATEGORY_SET_ID = c_category_set_id)
1933: AND ENABLED_FLAG = 'Y';
1934:
1935: -- CURSOR to check that the VBH Category is still assigned at the Item Level

Line 1939: FROM MTL_CATEGORY_SETS_VL

1935: -- CURSOR to check that the VBH Category is still assigned at the Item Level
1936:
1937: CURSOR l_vbh_chk_ctrl_lvl_csr (c_category_set_id VARCHAR2) is
1938: SELECT CONTROL_LEVEL, MULT_ITEM_CAT_ASSIGN_FLAG, STRUCTURE_ID
1939: FROM MTL_CATEGORY_SETS_VL
1940: WHERE CATEGORY_SET_ID = c_category_set_id;
1941:
1942: BEGIN
1943: BEGIN

Line 2331: FROM MTL_CATEGORY_SETS_VL

2327: MULTIPLE_CAT_ALLOWED EXCEPTION;
2328:
2329: CURSOR l_chk_ctrl_lvl_csr (c_category_set_id VARCHAR2) is
2330: SELECT CONTROL_LEVEL, MULT_ITEM_CAT_ASSIGN_FLAG, VALIDATE_FLAG
2331: FROM MTL_CATEGORY_SETS_VL
2332: WHERE CATEGORY_SET_ID = c_category_set_id;
2333:
2334: BEGIN
2335:

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 2884: WHERE table_name = 'MTL_CATEGORY_SETS_B'

2880: BEGIN -- Bug 3514304
2881:
2882: SELECT 1 into l_column_exists
2883: FROM all_tab_columns
2884: WHERE table_name = 'MTL_CATEGORY_SETS_B'
2885: AND column_name = 'HIERARCHY_ENABLED'
2886: AND owner = l_inv_schema;
2887:
2888: edw_log.put_line(' Hierarchy enabled column exists');

Line 2902: ' FROM MTL_CATEGORY_SETS ' ||

2898: l_rows_inserted := 0;
2899: l_cursor := dbms_sql.open_cursor;
2900:
2901: l_hierarchy_stmt := 'SELECT HIERARCHY_ENABLED, CATEGORY_SET_ID'||
2902: ' FROM MTL_CATEGORY_SETS ' ||
2903: ' WHERE CATEGORY_SET_NAME = :l_catset3_name';
2904:
2905: edw_log.put_line('Constructing the SQL statement: ' || l_hierarchy_stmt);
2906:

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: