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_PVT dependencies on PA_CI_TYPES_V

Line 1048: and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code = l_code

1044: is
1045: SELECT distinct ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1046: and ps.project_system_status_code =pc.project_system_status_code and ci_type_id = p_ci_type_id
1047: and ps.starting_status_flag = 'Y'
1048: and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code = l_code
1049: ;
1050: --Bug#13475251 end.
1051: /* mwxx
1052:

Line 1134: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_DRAFT';

1130: -- Bug#13475251 Changes start.
1131: -- select distinct count(*) into l_str from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1132: -- and ps.project_system_status_code =pc.project_system_status_code and ci_type_id=p_ci_type_id
1133: -- and ps.starting_status_flag = 'Y'
1134: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_DRAFT';
1135: -- if l_str = 1 then
1136: -- l_ci_system_status := 'CI_DRAFT';
1137: -- else
1138: -- select distinct count(*) into l_str1 from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code

Line 1141: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_WORKING';

1137: -- else
1138: -- select distinct count(*) into l_str1 from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1139: -- and ps.project_system_status_code =pc.project_system_status_code and ci_type_id=p_ci_type_id
1140: -- and ps.starting_status_flag = 'Y'
1141: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_WORKING';
1142: -- if l_str1 = 1 then
1143: -- l_ci_system_status := 'CI_WORKING';
1144: -- else
1145: -- l_ci_system_status := 'CI_DRAFT';