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.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_CI_STATUSES_V

Line 389: SELECT ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps, pa_control_items ci

385: l_num_of_actions NUMBER;
386: l_status VARCHAR2(30);
387: -- #Bug#13683760 changes start.
388: cursor c_get_working_status_code (p_ci_id NUMBER) is
389: SELECT ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps, pa_control_items ci
390: where ci.ci_id = p_ci_id and ci.ci_type_id = pc.ci_type_id
391: and ps.project_status_code=pc.project_status_code
392: and ps.project_system_status_code =pc.project_system_status_code
393: and ps.project_system_status_code = 'CI_WORKING' and rownum = 1;

Line 560: SELECT ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps, pa_control_items ci

556: l_user_id fnd_user.user_id%type;
557: -- End for Bug 6053648
558: -- #Bug#13683760 changes start.
559: cursor c_get_working_status_code (p_ci_id NUMBER) is
560: SELECT ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps, pa_control_items ci
561: where ci.ci_id = p_ci_id and ci.ci_type_id = pc.ci_type_id
562: and ps.project_status_code=pc.project_status_code
563: and ps.project_system_status_code =pc.project_system_status_code
564: and ps.project_system_status_code = 'CI_WORKING' and rownum = 1;