APPS.MTH_ITEM_DIMENSION_PKG dependencies on MTH_ITEMS_D

Line 32: from MTH_ITEMS_D

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
33: where item_PK_KEY = v_unassigned_key;
34: exception
35: when TOO_MANY_ROWS then
36: v_unassigned_item_name := null;

Line 211: MTH_ITEMS_D B

207: PARENT_NAME,
208: SYS_CONNECT_BY_PATH(LEVEL_FK_KEY,'/') PATH,
209: HIERARCHY_ID
210: FROM MTH_ITEM_HIERARCHY,
211: MTH_ITEMS_D B
212: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
213: START WITH B.ITEM_PK_KEY IS NOT NULL
214: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
215: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,

Line 217: FROM MTH_ITEMS_D) B

213: START WITH B.ITEM_PK_KEY IS NOT NULL
214: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
215: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
216: (SELECT ITEM_PK_KEY, ITEM_NAME
217: FROM MTH_ITEMS_D) B
218: WHERE A.PATH LIKE '/'
219: ||B.ITEM_PK_KEY
220: ||'%')
221: --The granuality level is item and this would be done

Line 980: from MTH_ITEMS_D

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
981: where item_PK_KEY = v_unassigned_key;
982: exception
983: when TOO_MANY_ROWS then
984: v_unassigned_item_name := null;

Line 1159: MTH_ITEMS_D B

1155: PARENT_NAME,
1156: SYS_CONNECT_BY_PATH(LEVEL_FK_KEY,'/') PATH,
1157: HIERARCHY_ID
1158: FROM MTH_ITEM_HIERARCHY,
1159: MTH_ITEMS_D B
1160: WHERE LEVEL_FK_KEY = B.ITEM_PK_KEY (+)
1161: START WITH B.ITEM_PK_KEY IS NOT NULL
1162: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
1163: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,

Line 1165: FROM MTH_ITEMS_D) B

1161: START WITH B.ITEM_PK_KEY IS NOT NULL
1162: CONNECT BY LEVEL_FK_KEY = PRIOR PARENT_FK_KEY
1163: AND HIERARCHY_ID = PRIOR HIERARCHY_ID) A,
1164: (SELECT ITEM_PK_KEY, ITEM_NAME
1165: FROM MTH_ITEMS_D) B
1166: WHERE A.PATH LIKE '/'
1167: ||B.ITEM_PK_KEY
1168: ||'%')
1169: --The granuality level is item and this would be done