APPS.EDW_ITEMS_M_C dependencies on MTL_CATEGORY_SETS_VL

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 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: