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_PROJ_STRUC_MAPPING_PUB dependencies on PA_PROJ_STRUCTURE_TYPES

Line 485: , pa_proj_structure_types str_type

481: FROM
482: pa_proj_element_versions ppv
483: , pa_proj_elements pae
484: , pa_proj_elem_ver_structure str_ver
485: , pa_proj_structure_types str_type
486: , pa_structure_types
487:
488: WHERE pae.name = l_task_name
489: AND pae.project_id = l_project_id

Line 908: , pa_proj_structure_types str_type

904: FROM
905: pa_proj_element_versions ppv
906: , pa_proj_elements pae
907: , pa_proj_elem_ver_structure str_ver
908: , pa_proj_structure_types str_type
909: , pa_structure_types
910: WHERE pae.name = l_task_name
911: AND pae.project_id = l_project_id
912: AND ppv.project_id = l_project_id

Line 1315: pa_proj_structure_types prjstrType,

1311: , pelever.attribute15 AS src_str_version_id
1312: , pstrType.structure_type AS structure_type
1313: FROM
1314: pa_proj_element_versions pelever,
1315: pa_proj_structure_types prjstrType,
1316: pa_structure_types pstrType
1317: WHERE
1318: pelever.object_type = 'PA_STRUCTURES'
1319: AND

Line 1781: -- , pa_proj_structure_types projStrType Bug 3693235 Performance Fix

1777: obRel.object_relationship_id
1778: FROM
1779: pa_proj_element_versions elever1
1780: , pa_proj_element_versions elever2
1781: -- , pa_proj_structure_types projStrType Bug 3693235 Performance Fix
1782: -- , pa_structure_types strType Bug 3693235 Performance Fix
1783: , pa_object_relationships obRel
1784: WHERE
1785: elever1.object_type = 'PA_TASKS'

Line 1792: AND exists (SELECT 'xyz' FROM pa_proj_structure_types WHERE proj_element_id = elever2.proj_element_id and structure_type_id = 6) -- Bug 3693235 Performance Fix

1788: -- Bug 3693235 Performance Fix
1789: --AND elever2.proj_element_id = projStrType.proj_element_id
1790: --AND projStrType.structure_type_id = strType.structure_type_id
1791: --AND strType.structure_type = 'FINANCIAL'
1792: AND exists (SELECT 'xyz' FROM pa_proj_structure_types WHERE proj_element_id = elever2.proj_element_id and structure_type_id = 6) -- Bug 3693235 Performance Fix
1793: AND elever1.project_id = l_project_id
1794: AND elever2.project_id = l_project_id
1795: AND elever1.project_id = elever2.project_id
1796: AND elever1.element_version_id = obRel.object_id_to1