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_PROC_BATCHES_PKG dependencies on CN_DIM_EXPLOSION_ALL

Line 264: FROM cn_dim_explosion_all

260: FROM cn_revenue_classes_all rc
261: WHERE org_id = g_org_id
262: AND NOT EXISTS(
263: SELECT 1
264: FROM cn_dim_explosion_all
265: WHERE dim_hierarchy_id = x_dim_hierarchy
266: AND value_external_id = rc.revenue_class_id
267: AND ancestor_external_id = rc.revenue_class_id);
268: BEGIN

Line 327: UPDATE cn_dim_explosion_all

323: WHERE dim_hierarchy_id = x_dim_hierarchy
324: AND external_id = CLASS.revenue_class_id
325: AND org_id = g_org_id));
326:
327: UPDATE cn_dim_explosion_all
328: SET ancestor_external_id = CLASS.revenue_class_id
329: WHERE ancestor_id IN(
330: SELECT value_id
331: FROM cn_hierarchy_nodes_all

Line 339: UPDATE cn_dim_explosion_all

335: AND dim_hierarchy_id = x_dim_hierarchy
336: AND ancestor_external_id IS NULL
337: AND org_id = g_org_id;
338:
339: UPDATE cn_dim_explosion_all
340: SET value_external_id = CLASS.revenue_class_id
341: WHERE value_id IN(
342: SELECT value_id
343: FROM cn_hierarchy_nodes_all