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_EQUIPMENT_PKG dependencies on MTH_EQUIP_HIERARCHY

Line 114: FROM MTH_EQUIP_HIERARCHY

110: BEGIN
111:
112: mth_util_pkg.log_msg('VALIDATE_GROUP_ID start', mth_util_pkg.G_DBG_PROC_FUN_START);
113: OPEN c_equip_hierarchy FOR 'Select NVL(GROUP_ID, 1) GROUP_ID, LEVEL_FK_KEY, HIERARCHY_ID, LEVEL_NUM, EFFECTIVE_DATE
114: FROM MTH_EQUIP_HIERARCHY
115: ORDER BY HIERARCHY_ID, LEVEL_NUM, LEVEL_FK_KEY, EFFECTIVE_DATE ';
116: FETCH c_equip_hierarchy BULK COLLECT INTO r_equip_hierarchy.GROUP_ID,
117: r_equip_hierarchy.LEVEL_FK_KEY,
118: r_equip_hierarchy.HIERARCHY_ID,

Line 177: FROM (SELECT level_num child_level_num,level_fk_key child_level_fk_key,Min(effective_date) child_date,hierarchy_id,parent_fk_key FROM mth_equip_hierarchy

173: v_error_flag_mp NUMBER DEFAULT 0 ;
174: v_error_flag_nep NUMBER DEFAULT 0 ;
175: CURSOR c_equip_hierarchy IS
176: SELECT parent_fk_key,child_level_fk_key,parent_level_fk_key,child_date,parent_date,child_level_num,parent_level_num,parent_level_num_incr
177: FROM (SELECT level_num child_level_num,level_fk_key child_level_fk_key,Min(effective_date) child_date,hierarchy_id,parent_fk_key FROM mth_equip_hierarchy
178: WHERE level_num >1
179: GROUP BY level_num,level_fk_key,hierarchy_id,parent_fk_key ) h_child,
180: (SELECT level_num parent_level_num, (level_num+1) parent_level_num_incr,level_fk_key parent_level_fk_key,Min(effective_date) parent_date ,hierarchy_id FROM mth_equip_hierarchy
181: WHERE level_num <10

Line 180: (SELECT level_num parent_level_num, (level_num+1) parent_level_num_incr,level_fk_key parent_level_fk_key,Min(effective_date) parent_date ,hierarchy_id FROM mth_equip_hierarchy

176: SELECT parent_fk_key,child_level_fk_key,parent_level_fk_key,child_date,parent_date,child_level_num,parent_level_num,parent_level_num_incr
177: FROM (SELECT level_num child_level_num,level_fk_key child_level_fk_key,Min(effective_date) child_date,hierarchy_id,parent_fk_key FROM mth_equip_hierarchy
178: WHERE level_num >1
179: GROUP BY level_num,level_fk_key,hierarchy_id,parent_fk_key ) h_child,
180: (SELECT level_num parent_level_num, (level_num+1) parent_level_num_incr,level_fk_key parent_level_fk_key,Min(effective_date) parent_date ,hierarchy_id FROM mth_equip_hierarchy
181: WHERE level_num <10
182: GROUP BY level_num,level_fk_key,hierarchy_id ) h_parent
183: WHERE
184: h_child.parent_fk_key = h_parent.parent_level_fk_key(+)

Line 255: FROM mth_equip_hierarchy h,

251: RETURN VARCHAR2 IS
252:
253: CURSOR c_equip_hierarchy IS
254: SELECT Count(*) record_count
255: FROM mth_equip_hierarchy h,
256: mth_equipment_denorm_d d,
257: (SELECT Min(from_date) from_date
258: FROM mth_run_log
259: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r

Line 331: FROM mth_equip_hierarchy h,

327: 7,d.level7_effective_date,
328: 8,d.level8_effective_date,
329: 9,d.level9_effective_date,
330: 10,d.equipment_effective_date) child_effective_date
331: FROM mth_equip_hierarchy h,
332: mth_equipment_denorm_d d,
333: (SELECT Min(from_date) from_date
334: FROM mth_run_log
335: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r

Line 453: FROM mth_equip_hierarchy) equip_hierarchy /*,

449: ORDER BY group_id ) previous_effective_date,
450: (Lead(effective_date)
451: over (PARTITION BY hierarchy_id,level_num,level_fk_key
452: ORDER BY group_id )) - 1/(24*60*60) expiration_date
453: FROM mth_equip_hierarchy) equip_hierarchy /*,
454: (SELECT
455: DISTINCT
456: MTH_RUN_LOG.FROM_DATE,
457: MTH_RUN_LOG.TO_DATE

Line 1504: MERGE INTO MTH_EQUIP_HIERARCHY MEQU

1500:
1501: -- Call GET_RUN_LOG_DATES
1502: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_HRCHY_UA_MAP',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
1503:
1504: MERGE INTO MTH_EQUIP_HIERARCHY MEQU
1505: USING
1506: (SELECT MDM.HIERARCHY_ID,
1507: 10 LEVEL_NUM,
1508: ME.EQUIPMENT_PK_KEY ,

Line 1559: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1555: CATCH_ALL.EQUIPMENT_NAME,
1556: CATCH_ALL.PARENT_NAME,
1557: 1)
1558: ;
1559: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1560:
1561: MERGE
1562: INTO
1563: MTH_EQUIP_HIERARCHY MEQ

Line 1563: MTH_EQUIP_HIERARCHY MEQ

1559: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1560:
1561: MERGE
1562: INTO
1563: MTH_EQUIP_HIERARCHY MEQ
1564: USING
1565: (
1566: WITH cntr AS
1567:

Line 1629: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1625: UN_ALL.LEVEL_NAME,
1626: UN_ALL.PARENT_NAME,
1627: 1)
1628: ;
1629: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1630:
1631: MERGE
1632: INTO
1633: MTH_EQUIP_HIERARCHY MEQB

Line 1633: MTH_EQUIP_HIERARCHY MEQB

1629: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1630:
1631: MERGE
1632: INTO
1633: MTH_EQUIP_HIERARCHY MEQB
1634: USING
1635: (SELECT
1636: distinct --Added to avoid MTH_EQUIP_HIERARCHY_U1 violation in case of
1637: --reassignments of same level to different parent (sasuren)

Line 1636: distinct --Added to avoid MTH_EQUIP_HIERARCHY_U1 violation in case of

1632: INTO
1633: MTH_EQUIP_HIERARCHY MEQB
1634: USING
1635: (SELECT
1636: distinct --Added to avoid MTH_EQUIP_HIERARCHY_U1 violation in case of
1637: --reassignments of same level to different parent (sasuren)
1638: MEH.HIERARCHY_ID,
1639: MEH.LEVEL_NUM,
1640: MEH.LEVEL_FK_KEY,

Line 1650: FROM MTH_EQUIP_HIERARCHY MEH

1646: --Commented to ensure distinct works fine in case reassignment happens on a
1647: --different date
1648: MEH.LEVEL_NAME,
1649: MTH_UTIL_PKG.MTH_UA_GET_MEANING UNASSIGNED_PARENT_NAME
1650: FROM MTH_EQUIP_HIERARCHY MEH
1651: WHERE
1652: MEH.LAST_UPDATE_DATE >= v_log_from_date AND
1653: MEH.LEVEL_FK_KEY <> -99999
1654:

Line 1699: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1695: MERGE_QUERY.LEVEL_NAME,
1696: MERGE_QUERY.UNASSIGNED_PARENT_NAME,
1697: 1)
1698: ;
1699: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1700:
1701: ----Call mth_run_log_post_load
1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);
1703: