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.PJI_REP_UTIL dependencies on PA_PROJECT_TYPES_ALL

Line 3305: , pa_project_types_all t

3301:
3302: SELECT DISTINCT UPPER(t.project_type_class_code)
3303: INTO x_project_type
3304: FROM pa_projects_all p
3305: , pa_project_types_all t
3306: WHERE 1=1
3307: AND p.project_id = p_project_Id
3308: AND p.project_type = t.project_type
3309: /*AND NVL(p.org_id,-99) = NVL(t.org_id,-99); -- Added NVL for bug 3989132*/

Line 5432: ,pa_project_types_all pt

5428: INTO l_proj_type_count
5429: FROM pji_xbs_denorm denorm
5430: ,pa_proj_elem_ver_structure vs
5431: ,pa_projects_all proj
5432: ,pa_project_types_all pt
5433: WHERE struct_type = 'PRG'
5434: AND sup_project_id = p_project_id
5435: AND struct_version_id IS NULL
5436: AND NVL(denorm.relationship_type,'WF') IN ('WF',l_relationship_type)