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_ITEM_HIERARCHY

Line 259: FROM MTH_ITEM_HIERARCHY,

255: PARENT_FK_KEY,
256: PARENT_NAME,
257: SYS_CONNECT_BY_PATH(LEVEL_FK_KEY,'/') PATH,
258: HIERARCHY_ID
259: FROM MTH_ITEM_HIERARCHY,
260: MTH_ITEMS_D B
261: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
262: START WITH B.ITEM_PK_KEY IS NOT NULL
263: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_key

Line 263: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_key

259: FROM MTH_ITEM_HIERARCHY,
260: MTH_ITEMS_D B
261: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
262: START WITH B.ITEM_PK_KEY IS NOT NULL
263: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_key
264: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > v_log_from_date
265: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= v_log_to_date
266: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
267: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,

Line 264: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > v_log_from_date

260: MTH_ITEMS_D B
261: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
262: START WITH B.ITEM_PK_KEY IS NOT NULL
263: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_key
264: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > v_log_from_date
265: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= v_log_to_date
266: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
267: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
268: (SELECT ITEM_PK_KEY, ITEM_NAME

Line 265: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= v_log_to_date

261: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
262: START WITH B.ITEM_PK_KEY IS NOT NULL
263: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_key
264: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > v_log_from_date
265: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= v_log_to_date
266: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
267: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
268: (SELECT ITEM_PK_KEY, ITEM_NAME
269: FROM MTH_ITEMS_D) B

Line 1225: FROM MTH_ITEM_HIERARCHY,

1221: PARENT_FK_KEY,
1222: PARENT_NAME,
1223: SYS_CONNECT_BY_PATH(LEVEL_FK_KEY,'/') PATH,
1224: HIERARCHY_ID
1225: FROM MTH_ITEM_HIERARCHY,
1226: MTH_ITEMS_D B
1227: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
1228: START WITH B.ITEM_PK_KEY IS NOT NULL
1229: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY

Line 1800: UPDATE MTH_ITEM_HIERARCHY_STG A

1796: --the start condition of the connect by query is the root node for
1797: --which the parent is null.
1798:
1799:
1800: UPDATE MTH_ITEM_HIERARCHY_STG A
1801: SET LEVEL_NUM =
1802: (SELECT LEVEL
1803: FROM MTH_ITEM_HIERARCHY_STG B
1804: WHERE A.LEVEL_FK = B.LEVEL_FK

Line 1803: FROM MTH_ITEM_HIERARCHY_STG B

1799:
1800: UPDATE MTH_ITEM_HIERARCHY_STG A
1801: SET LEVEL_NUM =
1802: (SELECT LEVEL
1803: FROM MTH_ITEM_HIERARCHY_STG B
1804: WHERE A.LEVEL_FK = B.LEVEL_FK
1805: AND A.HIERARCHY_NAME = B.HIERARCHY_NAME CONNECT BY PRIOR
1806: B.LEVEL_FK = B.PARENT_FK
1807: AND PRIOR B.HIERARCHY_NAME = A.HIERARCHY_NAME START

Line 1992: FROM MTH_ITEM_HIERARCHY,

1988: PARENT_FK_KEY,
1989: PARENT_NAME,
1990: SYS_CONNECT_BY_PATH(LEVEL_FK_KEY,'/') PATH,
1991: HIERARCHY_ID
1992: FROM MTH_ITEM_HIERARCHY,
1993: MTH_ITEMS_D B
1994: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
1995: START WITH B.ITEM_PK_KEY IS NOT NULL AND
1996: B.ITEM_PK_KEY IN

Line 1998: FROM mth_item_hierarchy a ,

1994: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
1995: START WITH B.ITEM_PK_KEY IS NOT NULL AND
1996: B.ITEM_PK_KEY IN
1997: (SELECT c.item_fk_key
1998: FROM mth_item_hierarchy a ,
1999: mth_item_categories_d bb,
2000: mth_item_denorm_d c
2001: WHERE (a.level_fk_key = c.level9_fk_key OR
2002: a.level_fk_key = c.level8_fk_key OR

Line 2205: FROM MTH_ITEM_HIERARCHY,

2201: PARENT_FK_KEY,
2202: PARENT_NAME,
2203: SYS_CONNECT_BY_PATH(LEVEL_FK_KEY,'/') PATH,
2204: HIERARCHY_ID
2205: FROM MTH_ITEM_HIERARCHY,
2206: MTH_ITEMS_D B
2207: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
2208: START WITH B.ITEM_PK_KEY IS NOT NULL
2209: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_val

Line 2209: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_val

2205: FROM MTH_ITEM_HIERARCHY,
2206: MTH_ITEMS_D B
2207: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
2208: START WITH B.ITEM_PK_KEY IS NOT NULL
2209: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_val
2210: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > p_log_from_date
2211: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= p_log_to_date
2212: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
2213: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,

Line 2210: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > p_log_from_date

2206: MTH_ITEMS_D B
2207: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
2208: START WITH B.ITEM_PK_KEY IS NOT NULL
2209: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_val
2210: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > p_log_from_date
2211: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= p_log_to_date
2212: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
2213: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
2214: (SELECT ITEM_PK_KEY, ITEM_NAME

Line 2211: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= p_log_to_date

2207: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
2208: START WITH B.ITEM_PK_KEY IS NOT NULL
2209: and MTH_ITEM_HIERARCHY.level_fk_key<> v_unassigned_val
2210: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > p_log_from_date
2211: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE <= p_log_to_date
2212: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
2213: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
2214: (SELECT ITEM_PK_KEY, ITEM_NAME
2215: FROM MTH_ITEMS_D) B

Line 4405: INSERT INTO MTH_ITEM_HIERARCHY (HIERARCHY_ID,

4401:
4402: -- Call GET_RUN_LOG_DATES
4403: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_UA_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
4404:
4405: INSERT INTO MTH_ITEM_HIERARCHY (HIERARCHY_ID,
4406: LEVEL_FK_KEY,
4407: PARENT_FK_KEY,
4408: SYSTEM_FK_KEY,
4409: CREATION_DATE,

Line 4442: MTH_ITEM_HIERARCHY MIH )UN_REC

4438: SELECT MIH.HIERARCHY_ID,
4439: MIH.LEVEL_FK_KEY ,
4440: MIH.LEVEL_NAME
4441: FROM
4442: MTH_ITEM_HIERARCHY MIH )UN_REC
4443: )
4444: ;
4445: mth_util_pkg.log_msg('Number of rows inserted in MTH_ITEM_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4446:

Line 4445: mth_util_pkg.log_msg('Number of rows inserted in MTH_ITEM_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4441: FROM
4442: MTH_ITEM_HIERARCHY MIH )UN_REC
4443: )
4444: ;
4445: mth_util_pkg.log_msg('Number of rows inserted in MTH_ITEM_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4446:
4447: ----Call mth_run_log_post_load
4448: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_UA_D',v_unassigned_val);
4449: mth_util_pkg.log_msg('MTH_ITEM_HRCHY_UNASSIGNED_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);