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.MTH_ITEM_DIMENSION_PKG dependencies on MTH_UTIL_PKG

Line 28: v_unassigned_key := MTH_UTIL_PKG.MTH_UA_GET_VAL;

24: --group by clause.
25: --Maximun nuumber of leves supported is 10.
26: --Item will be at lowest level i.e. 10.
27:
28: v_unassigned_key := MTH_UTIL_PKG.MTH_UA_GET_VAL;
29:
30: BEGIN
31: SELECT ITEM_NAME into v_unassigned_item_name
32: from MTH_ITEMS_D

Line 226: MTH_UTIL_PKG.MTH_UA_GET_VAL item_fk_key

222: -- for all the hierarchies
223: GROUP BY HIERARCHY_ID,ITEM_PK_KEY
224: UNION
225: select mdh.hierarchy_id,
226: MTH_UTIL_PKG.MTH_UA_GET_VAL item_fk_key
227: ,v_unassigned_key level1_level_key
228: ,v_unassigned_key level2_level_key
229: ,v_unassigned_key level3_level_key
230: ,v_unassigned_key level4_level_key

Line 255: mth_util_pkg.mth_hrchy_balance_load('MTH_ITEM_DENORM_D');

251: where mdh.dimension_name= 'ITEM' and
252: mdll.hierarchy_id (+) = mdh.hierarchy_id);
253:
254: -- Balance the item denorm table
255: mth_util_pkg.mth_hrchy_balance_load('MTH_ITEM_DENORM_D');
256:
257: -- Push up and fill the level key and name for the ones with NULL
258:
259: UPDATE MTH_ITEM_DENORM_D

Line 893: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL

889: decode(level2_fk_key,NULL,0,1) +
890: decode(level1_fk_key,NULL,0,1)) over(PARTITION BY hierarchy_id)
891: max_level--maximum level in the hierarchy
892: FROM MTH.MTH_ITEM_DENORM_D_TMP
893: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL
894: )
895: WHERE c_level 896: AND level9_fk_key IS NOT NULL
897: )';

Line 976: v_unassigned_key := MTH_UTIL_PKG.MTH_UA_GET_VAL;

972: v_unassigned_item_name varchar2(240);
973: v_unassigned_category_name varchar2(240);
974: BEGIN
975:
976: v_unassigned_key := MTH_UTIL_PKG.MTH_UA_GET_VAL;
977:
978: BEGIN
979: SELECT ITEM_NAME into v_unassigned_item_name
980: from MTH_ITEMS_D

Line 1174: MTH_UTIL_PKG.MTH_UA_GET_VAL item_fk_key

1170: -- for all the hierarchies
1171: GROUP BY HIERARCHY_ID,ITEM_PK_KEY
1172: UNION
1173: select mdh.hierarchy_id,
1174: MTH_UTIL_PKG.MTH_UA_GET_VAL item_fk_key
1175: ,v_unassigned_key level1_level_key
1176: ,v_unassigned_key level2_level_key
1177: ,v_unassigned_key level3_level_key
1178: ,v_unassigned_key level4_level_key