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_SOLVE dependencies on ZPB_HIER_SCOPE

Line 1253: zpb_hier_scope c

1249: MINUS
1250: select distinct a.epb_id, b.aw_name
1251: from zpb_hierarchies a,
1252: zpb_dimensions b,
1253: zpb_hier_scope c
1254: where a.dimension_id = b.dimension_id
1255: and b.bus_area_id = l_ba_id
1256: and b.is_data_dim = 'YES'
1257: and a.hierarchy_id = c.hierarchy_id

Line 1269: zpb_hier_scope c

1265: MINUS
1266: select distinct a.EPB_ID, b.aw_name
1267: from zpb_hierarchies a,
1268: zpb_dimensions b,
1269: zpb_hier_scope c
1270: where a.dimension_id = b.dimension_id
1271: and b.bus_area_id = l_ba_id
1272: and b.is_data_dim = 'YES'
1273: and a.hierarchy_id = c.hierarchy_id

Line 1286: zpb_hier_scope c

1282: select count(*)
1283: into l_count
1284: from zpb_dimensions a,
1285: zpb_hierarchies b,
1286: zpb_hier_scope c
1287: where a.aw_name = each.dimension
1288: and a.bus_area_id = l_ba_id
1289: and a.dimension_id = b.dimension_id
1290: and b.epb_id <> 'NULL_GID'

Line 1319: zpb_hier_scope c

1315: select a.DEFAULT_HIER
1316: into l_new_hier
1317: from zpb_dimensions a,
1318: zpb_hierarchies b,
1319: zpb_hier_scope c
1320: where a.aw_name = each.dimension
1321: and a.bus_area_id = l_ba_id
1322: and a.dimension_id = b.dimension_id
1323: and b.epb_id = a.default_hier

Line 1336: zpb_hier_scope c

1332: select min(b.epb_id)
1333: into l_new_hier
1334: from zpb_dimensions a,
1335: zpb_hierarchies b,
1336: zpb_hier_scope c
1337: where a.aw_name = each.dimension
1338: and a.bus_area_id = l_ba_id
1339: and a.dimension_id = b.dimension_id
1340: and b.hierarchy_id = c.hierarchy_id

Line 1394: zpb_hier_scope c

1390: select count(*)
1391: into l_count
1392: from zpb_dimensions a,
1393: zpb_hierarchies b,
1394: zpb_hier_scope c
1395: where a.aw_name = each.dimension
1396: and a.bus_area_id = l_ba_id
1397: and a.dimension_id = b.dimension_id
1398: and b.epb_id <> 'NULL_GID'

Line 1427: zpb_hier_scope c

1423: select a.DEFAULT_HIER
1424: into l_new_hier
1425: from zpb_dimensions a,
1426: zpb_hierarchies b,
1427: zpb_hier_scope c
1428: where a.aw_name = each.dimension
1429: and a.bus_area_id = l_ba_id
1430: and a.dimension_id = b.dimension_id
1431: and b.epb_id = a.default_hier

Line 1444: zpb_hier_scope c

1440: select min(b.epb_id)
1441: into l_new_hier
1442: from zpb_dimensions a,
1443: zpb_hierarchies b,
1444: zpb_hier_scope c
1445: where a.aw_name = each.dimension
1446: and a.bus_area_id = l_ba_id
1447: and a.dimension_id = b.dimension_id
1448: and b.hierarchy_id = c.hierarchy_id