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.BSC_DIMENSION_LEVELS_PVT dependencies on DUAL

Line 1341: FROM DUAL;

1337:
1338: IF (UPPER(p_table_name) = 'BSC_SYS_DIM_LEVELS_B') THEN
1339: SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL
1340: INTO l_next
1341: FROM DUAL;
1342: ELSIF (UPPER(p_table_name) = 'BSC_SYS_DIM_GROUPS_TL') THEN
1343: SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL
1344: INTO l_next
1345: FROM DUAL;

Line 1345: FROM DUAL;

1341: FROM DUAL;
1342: ELSIF (UPPER(p_table_name) = 'BSC_SYS_DIM_GROUPS_TL') THEN
1343: SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL
1344: INTO l_next
1345: FROM DUAL;
1346: ELSIF (UPPER(p_table_name) = 'BSC_SYS_MEASURES') THEN
1347: SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL
1348: INTO l_next
1349: FROM DUAL;

Line 1349: FROM DUAL;

1345: FROM DUAL;
1346: ELSIF (UPPER(p_table_name) = 'BSC_SYS_MEASURES') THEN
1347: SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL
1348: INTO l_next
1349: FROM DUAL;
1350: ELSIF (UPPER(p_table_name) = 'BSC_SYS_DATASETS_TL') THEN
1351: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL
1352: INTO l_next
1353: FROM DUAL;

Line 1353: FROM DUAL;

1349: FROM DUAL;
1350: ELSIF (UPPER(p_table_name) = 'BSC_SYS_DATASETS_TL') THEN
1351: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL
1352: INTO l_next
1353: FROM DUAL;
1354: ELSIF (UPPER(p_table_name) = 'BSC_KPIS_B') THEN
1355: SELECT BSC_INDICATOR_ID_S.NEXTVAL
1356: INTO l_next
1357: FROM DUAL;

Line 1357: FROM DUAL;

1353: FROM DUAL;
1354: ELSIF (UPPER(p_table_name) = 'BSC_KPIS_B') THEN
1355: SELECT BSC_INDICATOR_ID_S.NEXTVAL
1356: INTO l_next
1357: FROM DUAL;
1358: ELSE
1359: l_sql := 'select NVL(max(' || p_column_name || '), 0) + 1 ' ||
1360: ' from ' || p_table_name;
1361: