APPS.EDW_ITEMS_M_C dependencies on MTL_CATEGORIES

Line 399: MTL_CATEGORIES CAT,

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

Line 1141: MTL_CATEGORIES CAT,

1137: AND SETS.LANGUAGE = userenv('LANG')
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

Line 2080: ||',MTL_CATEGORIES_VL MTC';

2076: /* Bug 2234621
2077:
2078: l_from_clause := ' FROM '||' FND_FLEX_VALUE_CHILDREN_V FFVC'
2079: ||','||p_view_name||' LCV_VIEW'
2080: ||',MTL_CATEGORIES_VL MTC';
2081:
2082: */
2083: l_from_clause := ' from ' || 'FND_FLEX_VALUE_CHILDREN_V FFVC'
2084: || ',' || p_view_name || ' LCV_VIEW';

Line 2140: ||',MTL_CATEGORIES_VL PARENT_MTC'

2136: /* Bug 2234621
2137:
2138: l_from_clause := ' FROM '||l_prior_staging_table_name||' PARENT_STAGING'
2139: ||','||p_view_name||' PARENT_LCV_VIEW'
2140: ||',MTL_CATEGORIES_VL PARENT_MTC'
2141: ||',FND_FLEX_VALUE_CHILDREN_V FFVC'
2142: ||','||p_view_name||' LCV_VIEW'
2143: ||',MTL_CATEGORIES_VL MTC';
2144: */

Line 2143: ||',MTL_CATEGORIES_VL MTC';

2139: ||','||p_view_name||' PARENT_LCV_VIEW'
2140: ||',MTL_CATEGORIES_VL PARENT_MTC'
2141: ||',FND_FLEX_VALUE_CHILDREN_V FFVC'
2142: ||','||p_view_name||' LCV_VIEW'
2143: ||',MTL_CATEGORIES_VL MTC';
2144: */
2145:
2146: l_from_clause := ' from ' || l_prior_staging_table_name || ' PARENT_STAGING, '
2147: || ' FND_FLEX_VALUE_CHILDREN_V FFVC'