APPS.MTH_ITEM_DIMENSION_PKG dependencies on MTH_DIM_HIERARCHY

Line 19: UPDATE MTH_DIM_HIERARCHY DH

15:
16: PROCEDURE UPDATE_ITEM_HIER_LVL_IN_DIM_HR
17: IS
18: BEGIN
19: UPDATE MTH_DIM_HIERARCHY DH
20: SET dh.last_update_date = SYSDATE,
21: DH.NUMBER_OF_LEVEL =
22: (SELECT
23: Max(decode(level9_fk_key,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,NULL,0,1) +

Line 300: mth_dim_hierarchy mdh,

296: ,v_unassigned_category_name level7_name
297: ,v_unassigned_category_name level8_name
298: ,v_unassigned_category_name level9_name
299: from dual,
300: mth_dim_hierarchy mdh,
301: (select distinct hierarchy_id
302: from mth_dim_level_lookup) mdll
303: where mdh.dimension_name= 'ITEM' and
304: mdll.hierarchy_id (+) = mdh.hierarchy_id);

Line 807: -- UPDATE the number of levels in mth_dim_hierarchy

803: From mth_item_denorm_d
804: Where LEVEL1_FK_KEY is not null and level_NUM = 2;
805:
806:
807: -- UPDATE the number of levels in mth_dim_hierarchy
808: -- First reset number of levels in mth_dim_hierarchy for all item hierarchies
809: UPDATE MTH_DIM_HIERARCHY
810: SET NUMBER_OF_LEVEL = NULL
811: WHERE dimension_name = 'ITEM';

Line 808: -- First reset number of levels in mth_dim_hierarchy for all item hierarchies

804: Where LEVEL1_FK_KEY is not null and level_NUM = 2;
805:
806:
807: -- UPDATE the number of levels in mth_dim_hierarchy
808: -- First reset number of levels in mth_dim_hierarchy for all item hierarchies
809: UPDATE MTH_DIM_HIERARCHY
810: SET NUMBER_OF_LEVEL = NULL
811: WHERE dimension_name = 'ITEM';
812:

Line 809: UPDATE MTH_DIM_HIERARCHY

805:
806:
807: -- UPDATE the number of levels in mth_dim_hierarchy
808: -- First reset number of levels in mth_dim_hierarchy for all item hierarchies
809: UPDATE MTH_DIM_HIERARCHY
810: SET NUMBER_OF_LEVEL = NULL
811: WHERE dimension_name = 'ITEM';
812:
813: UPDATE_ITEM_HIER_LVL_IN_DIM_HR();

Line 1262: mth_dim_hierarchy mdh,

1258: ,v_unassigned_category_name level7_name
1259: ,v_unassigned_category_name level8_name
1260: ,v_unassigned_category_name level9_name
1261: from dual,
1262: mth_dim_hierarchy mdh,
1263: (select distinct hierarchy_id
1264: from mth_dim_level_lookup) mdll
1265: where mdh.dimension_name= 'ITEM' and
1266: mdll.hierarchy_id (+) = mdh.hierarchy_id);

Line 3995: mth_dim_hierarchy mdh

3991: decode(level1_fk_key,NULL,0,MTH_UTIL_PKG.MTH_UA_GET_VAL,0,1)) min_level
3992: FROM MTH_ITEM_DENORM_D_TMP
3993: WHERE item_fk_key <> MTH_UTIL_PKG.MTH_UA_GET_VAL
3994: GROUP BY hierarchy_id) id,
3995: mth_dim_hierarchy mdh
3996: WHERE id.hierarchy_id = mdh.hierarchy_id;
3997:
3998:
3999: BEGIN

Line 4076: -- Step 6: Update MTH_DIM_HIERARCHY for item hierarchy where number of level

4072: -- key and corresponding name to -99999, and 'Unassigned'
4073: UPD_ITEM_DENORM_TMP_UNASSIGNED(v_unassigned_key, v_unassigned_category_name);
4074:
4075:
4076: -- Step 6: Update MTH_DIM_HIERARCHY for item hierarchy where number of level
4077: -- is NULL or 0 with the number of levels found in item denorm table
4078: -- if the item hierarchy exists in item deorm table
4079: UPDATE_ITEM_HIER_LVL_IN_DIM_HR();
4080: /*

Line 4081: UPDATE MTH_DIM_HIERARCHY DH

4077: -- is NULL or 0 with the number of levels found in item denorm table
4078: -- if the item hierarchy exists in item deorm table
4079: UPDATE_ITEM_HIER_LVL_IN_DIM_HR();
4080: /*
4081: UPDATE MTH_DIM_HIERARCHY DH
4082: SET dh.last_update_date = SYSDATE,
4083: DH.NUMBER_OF_LEVEL =
4084: -- (SELECT num_levels
4085: -- FROM

Line 4345: UPDATE MTH_DIM_HIERARCHY

4341: -- THEN
4342: -- set the number of levels in the dim hierarchy table
4343: IF ( v_num_levels IS NULL OR
4344: v_num_levels < r_hid_and_levels.max_level ) THEN
4345: UPDATE MTH_DIM_HIERARCHY
4346: SET NUMBER_OF_LEVEL = r_hid_and_levels.max_level
4347: WHERE dimension_name= 'ITEM' and
4348: hierarchy_id = r_hid_and_levels.hierarchy_id;
4349: END IF;

Line 4431: MTH_DIM_HIERARCHY MDM

4427: MID.ITEM_NAME LEVEL_NAME
4428: FROM
4429: MTH_ITEMS_D MID,
4430: MTH_SYSTEMS_SETUP MSS,
4431: MTH_DIM_HIERARCHY MDM
4432: WHERE MID.CREATION_DATE >v_log_from_date AND
4433: MID.CREATION_DATE <= v_log_to_date AND
4434: MID.ITEM_PK_KEY <> MTH_UTIL_PKG.MTH_UA_GET_VAL() AND
4435: MID.SYSTEM_FK_KEY = MSS.SYSTEM_PK_KEY AND