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_DEBUG dependencies on ZPB_HIERARCHIES

Line 113: (select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,

109: dvl.pers_cwm_name,
110: dvl.shar_cwm_name,
111: dvl.aw_name,
112: dvl.dimension_id,
113: (select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,
114: dvl.epb_id
115: from zpb_dimensions_vl dvl
116: where bus_area_id = p_bus_area_id and
117: is_data_dim='YES'

Line 131: from zpb_hierarchies_vl hier,

127: epb_id,
128: tab1.table_name pers_table_name,
129: tab2.table_name shar_table_name,
130: hierarchy_id
131: from zpb_hierarchies_vl hier,
132: zpb_tables tab1,
133: zpb_tables tab2
134: where hier.dimension_id = l_dim_id and
135: hier.pers_table_id = tab1.table_id and

Line 497: (select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,

493: dvl.pers_cwm_name,
494: dvl.shar_cwm_name,
495: dvl.aw_name,
496: dvl.dimension_id,
497: (select count(*) from zpb_hierarchies where dimension_id = dvl.dimension_id and hier_type<>'NULL') hier_cnt,
498: dvl.epb_id
499: from zpb_dimensions_vl dvl
500: where bus_area_id = p_bus_area_id and
501: is_data_dim='YES'

Line 515: from zpb_hierarchies_vl hier,

511: epb_id,
512: tab1.table_name pers_table_name,
513: tab2.table_name shar_table_name,
514: hierarchy_id
515: from zpb_hierarchies_vl hier,
516: zpb_tables tab1,
517: zpb_tables tab2
518: where hier.dimension_id = l_dim_id and
519: hier.pers_table_id = tab1.table_id and