APPS.MTH_ITEM_DIMENSION_PKG dependencies on MTH_ITEMS_D

Line 81: from MTH_ITEMS_D

77: v_unassigned_key := MTH_UTIL_PKG.MTH_UA_GET_VAL;
78:
79: BEGIN
80: SELECT ITEM_NAME into v_unassigned_item_name
81: from MTH_ITEMS_D
82: where item_PK_KEY = v_unassigned_key;
83: exception
84: when TOO_MANY_ROWS then
85: v_unassigned_item_name := null;

Line 260: MTH_ITEMS_D B

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
264: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > v_log_from_date

Line 269: FROM MTH_ITEMS_D) B

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
270: WHERE A.PATH = ('/' || B.ITEM_PK_KEY ) OR
271: A.PATH LIKE '/' || B.ITEM_PK_KEY || '/%' )
272:
273: --The granuality level is item and this would be done

Line 1047: from MTH_ITEMS_D

1043: v_unassigned_key := MTH_UTIL_PKG.MTH_UA_GET_VAL;
1044:
1045: BEGIN
1046: SELECT ITEM_NAME into v_unassigned_item_name
1047: from MTH_ITEMS_D
1048: where item_PK_KEY = v_unassigned_key;
1049: exception
1050: when TOO_MANY_ROWS then
1051: v_unassigned_item_name := null;

Line 1226: MTH_ITEMS_D B

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
1230: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,

Line 1232: FROM MTH_ITEMS_D) B

1228: START WITH B.ITEM_PK_KEY IS NOT NULL
1229: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
1230: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
1231: (SELECT ITEM_PK_KEY, ITEM_NAME
1232: FROM MTH_ITEMS_D) B
1233: WHERE A.PATH = ('/' || B.ITEM_PK_KEY ) OR
1234: A.PATH LIKE '/' || B.ITEM_PK_KEY || '/%' )
1235: --The granuality level is item and this would be done
1236: -- for all the hierarchies

Line 1993: MTH_ITEMS_D B

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
1997: (SELECT c.item_fk_key

Line 2020: FROM MTH_ITEMS_D) B

2016: a.LAST_UPDATE_DATE <= p_log_to_date)
2017: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
2018: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
2019: (SELECT ITEM_PK_KEY, ITEM_NAME
2020: FROM MTH_ITEMS_D) B
2021: WHERE A.PATH = ('/' || B.ITEM_PK_KEY ) OR
2022: A.PATH LIKE '/' || B.ITEM_PK_KEY || '/%' )
2023: GROUP BY HIERARCHY_ID,ITEM_PK_KEY ) ;
2024:

Line 2206: MTH_ITEMS_D B

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
2210: AND MTH_ITEM_HIERARCHY.LAST_UPDATE_DATE > p_log_from_date

Line 2215: FROM MTH_ITEMS_D) B

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
2216: WHERE A.PATH = ('/' || B.ITEM_PK_KEY ) OR
2217: A.PATH LIKE '/' || B.ITEM_PK_KEY || '/%' )
2218: GROUP BY HIERARCHY_ID,ITEM_PK_KEY );
2219:

Line 4006: from MTH_ITEMS_D

4002:
4003:
4004: BEGIN
4005: SELECT ITEM_NAME into v_unassigned_item_name
4006: from MTH_ITEMS_D
4007: where item_PK_KEY = v_unassigned_key;
4008: exception
4009: when TOO_MANY_ROWS then
4010: v_unassigned_item_name := null;

Line 4429: MTH_ITEMS_D MID,

4425: FROM (SELECT MDM.HIERARCHY_ID HIERARCHY_ID,
4426: MID.ITEM_PK_KEY LEVEL_FK_KEY,
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