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.ZPB_BUSAREA_VAL dependencies on ZPB_BUSAREA_HIERARCHIES_VL

Line 890: select hierarchy_id, name from ZPB_BUSAREA_HIERARCHIES_VL

886: where version_id = p_version_id
887: order by logical_dim_id, hierarchy_id;
888:
889: cursor c_hiers is
890: select hierarchy_id, name from ZPB_BUSAREA_HIERARCHIES_VL
891: where version_id = p_version_id
892: order by logical_dim_id;
893:
894: begin

Line 1252: from ZPB_BUSAREA_HIERARCHIES_VL

1248: --end if;
1249:
1250: select count(*), decode(count(*), 0, 'Y', 'N')
1251: into l_count, l_no_hierarchies
1252: from ZPB_BUSAREA_HIERARCHIES_VL
1253: where DIMENSION_ID = each.DIMENSION_ID
1254: and LOGICAL_DIM_ID = each.LOGICAL_DIM_ID
1255: and VERSION_ID = p_version_id;
1256:

Line 1390: ZPB_BUSAREA_HIERARCHIES_VL B

1386:
1387: l_command := 'select A.HIERARCHY_ID, A.VERSION_ID, A.CURRENT_VERSION
1388: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES
1389: ('||l_ba_id||','''||l_vers_type||''')) A,
1390: ZPB_BUSAREA_HIERARCHIES_VL B
1391: where A.HIERARCHY_ID = B.HIERARCHY_ID
1392: and A.LOGICAL_DIM_ID = B.LOGICAL_DIM_ID
1393: and B.VERSION_ID = '||p_version_id||'
1394: and B.LOGICAL_DIM_ID = '||each.LOGICAL_DIM_ID||'