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_DIMENSIONS

Line 1252: zpb_dimensions b,

1248: and hierarchy <> 'NONE'
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'

Line 1268: zpb_dimensions b,

1264: and hierarchy <> 'NONE'
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'

Line 1284: from zpb_dimensions a,

1280: -- First check how many hiers are left, if none, we need to reset to NONE
1281: --
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

Line 1317: from zpb_dimensions a,

1313: --
1314: begin
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

Line 1334: from zpb_dimensions a,

1330: -- first one
1331: --
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

Line 1392: from zpb_dimensions a,

1388: -- First check how many hiers are left, if none, we need to reset to NONE
1389: --
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

Line 1425: from zpb_dimensions a,

1421: --
1422: begin
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

Line 1442: from zpb_dimensions a,

1438: -- first one
1439: --
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