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.CN_DIMENSIONS_PKG dependencies on CN_DIM_HIERARCHIES

Line 194: from cn_dim_hierarchies d, cn_head_hierarchies h

190:
191: -- remove dangling head hierarchies, dim hierarchies and tree fragments
192: delete from cn_hierarchy_nodes e where dim_hierarchy_id in
193: (select d.dim_hierarchy_id
194: from cn_dim_hierarchies d, cn_head_hierarchies h
195: where h.dimension_id = X_DIMENSION_ID
196: --R12 MOAC Changes--Start
197: and h.org_id = X_ORG_ID
198: and h.org_id = d.org_id

Line 203: from cn_dim_hierarchies d, cn_head_hierarchies h

199: --R12 MOAC Changes--End
200: and d.header_dim_hierarchy_id = h.head_hierarchy_id);
201: delete from cn_hierarchy_edges e where dim_hierarchy_id in
202: (select d.dim_hierarchy_id
203: from cn_dim_hierarchies d, cn_head_hierarchies h
204: where h.dimension_id = X_DIMENSION_ID
205: --R12 MOAC Changes--Start
206: and h.org_id = X_ORG_ID
207: and h.org_id = d.org_id

Line 210: delete from cn_dim_hierarchies d where header_dim_hierarchy_id in

206: and h.org_id = X_ORG_ID
207: and h.org_id = d.org_id
208: --R12 MOAC Changes--End
209: and d.header_dim_hierarchy_id = h.head_hierarchy_id);
210: delete from cn_dim_hierarchies d where header_dim_hierarchy_id in
211: (select head_hierarchy_id from cn_head_hierarchies
212: where dimension_id = X_DIMENSION_ID
213: --R12 MOAC Changes--Start
214: and org_id = X_ORG_ID);