DBA Data[Home] [Help]

APPS.MTH_ITEM_DIMENSION_PKG dependencies on MTH_DIM_LEVEL_LOOKUP

Line 250: from mth_dim_level_lookup) mdll

246: ,v_unassigned_category_name level9_name
247: from dual,
248: mth_dim_hierarchy mdh,
249: (select distinct hierarchy_id
250: from mth_dim_level_lookup) mdll
251: where mdh.dimension_name= 'ITEM' and
252: mdll.hierarchy_id (+) = mdh.hierarchy_id);
253:
254: -- Balance the item denorm table

Line 1198: from mth_dim_level_lookup) mdll

1194: ,v_unassigned_category_name level9_name
1195: from dual,
1196: mth_dim_hierarchy mdh,
1197: (select distinct hierarchy_id
1198: from mth_dim_level_lookup) mdll
1199: where mdh.dimension_name= 'ITEM' and
1200: mdll.hierarchy_id (+) = mdh.hierarchy_id);
1201:
1202: -- Balance the item denorm table