APPS.FII_GL_CCID_C dependencies on MTL_CATEGORIES

Line 1206: mtl_categories mtc,

1202: l_stmt := 'UPDATE fii_gl_ccid_dimensions glcc
1203: SET (glcc.product_id, glcc.PROD_CATEGORY_ID) =
1204: (SELECT flx1.flex_value_id, mtc.category_id
1205: FROM gl_code_combinations glccd,
1206: mtl_categories mtc,
1207: fnd_id_flex_segments seg1,
1208: fnd_flex_values flx1
1209: WHERE glccd.code_combination_id = glcc.code_combination_id
1210: AND mtc.structure_id = ' || g_mtc_structure_id || '

Line 1273: mtl_categories cat

1269:
1270: CURSOR c_dup_prod_cat (p_ccid NUMBER) IS
1271: SELECT cat.description cat_name
1272: FROM fii_gl_ccid_prod_int int,
1273: mtl_categories cat
1274: WHERE int.code_combination_id = p_ccid
1275: AND int.prod_category_id = cat.category_id;
1276:
1277: BEGIN

Line 1986: g_phase := 'Getting segment name in MTL_CATEGORIES associated with product structure';

1982: End if;
1983: end;
1984:
1985:
1986: g_phase := 'Getting segment name in MTL_CATEGORIES associated with product structure';
1987: If g_debug_flag = 'Y' then
1988: FII_UTIL.Write_Log(g_phase);
1989: End if;
1990: