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.AMS_DM_SCORE_PVT dependencies on AMS_DM_SCORES_ALL_B_S

Line 410: SELECT ams_dm_scores_all_b_s.NEXTVAL

406:
407: l_is_org_prod BOOLEAN;
408:
409: CURSOR c_id IS
410: SELECT ams_dm_scores_all_b_s.NEXTVAL
411: FROM dual;
412:
413: CURSOR c_id_exists (l_id IN NUMBER) IS
414: SELECT 1

Line 765: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s

761: FROM ams_user_statuses_vl
762: WHERE user_status_id = p_id;
763:
764: CURSOR c_target_id (p_score_id IN NUMBER) IS
765: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s
766: WHERE m.model_id = s.model_id
767: AND s.score_id = p_score_id
768: ;
769: BEGIN

Line 2566: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s

2562: WHERE score_id = p_score_id
2563: ;
2564:
2565: CURSOR c_target (p_score_id IN NUMBER) IS
2566: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s
2567: WHERE m.model_id = s.model_id
2568: AND s.score_id = p_score_id
2569: ;
2570: