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 491: , pa_proj_structure_types str_type

487: FROM
488: pa_proj_element_versions ppv
489: , pa_proj_elements pae
490: , pa_proj_elem_ver_structure str_ver
491: , pa_proj_structure_types str_type
492: , pa_structure_types
493:
494: WHERE pae.name = l_task_name
495: AND pae.project_id = l_project_id

Line 939: , pa_proj_structure_types str_type

935: FROM
936: pa_proj_element_versions ppv
937: , pa_proj_elements pae
938: , pa_proj_elem_ver_structure str_ver
939: , pa_proj_structure_types str_type
940: , pa_structure_types
941: WHERE pae.name = l_task_name
942: AND pae.project_id = l_project_id
943: AND ppv.project_id = l_project_id

Line 1353: pa_proj_structure_types prjstrType,

1349: DISTINCT pelever.attribute15 AS src_str_version_id
1350: --, pstrType.structure_type AS structure_type Commented for Bug 14197220 As these column not at all used
1351: FROM
1352: pa_proj_element_versions pelever,
1353: pa_proj_structure_types prjstrType,
1354: pa_structure_types pstrType
1355: WHERE
1356: pelever.object_type = 'PA_STRUCTURES'
1357: AND

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

1815: obRel.object_relationship_id
1816: FROM
1817: pa_proj_element_versions elever1
1818: , pa_proj_element_versions elever2
1819: -- , pa_proj_structure_types projStrType Bug 3693235 Performance Fix
1820: -- , pa_structure_types strType Bug 3693235 Performance Fix
1821: , pa_object_relationships obRel
1822: WHERE
1823: elever1.object_type = 'PA_TASKS'

Line 1830: 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

1826: -- Bug 3693235 Performance Fix
1827: --AND elever2.proj_element_id = projStrType.proj_element_id
1828: --AND projStrType.structure_type_id = strType.structure_type_id
1829: --AND strType.structure_type = 'FINANCIAL'
1830: 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
1831: AND elever1.project_id = l_project_id
1832: AND elever2.project_id = l_project_id
1833: AND elever1.project_id = elever2.project_id
1834: AND elever1.element_version_id = obRel.object_id_to1