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_STRUCTURE_TYPES

Line 492: , pa_structure_types

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
496: AND ppv.project_id = l_project_id

Line 503: AND str_type.structure_type_id = pa_structure_types.structure_type_id

499: AND pae.object_type = 'PA_TASKS'
500: AND ppv.object_type = 'PA_TASKS'
501: AND str_ver.project_id = l_project_id
502: AND str_ver.proj_element_id = str_type.proj_element_id
503: AND str_type.structure_type_id = pa_structure_types.structure_type_id
504: AND pa_structure_types.structure_type = 'FINANCIAL'
505: AND pae.project_id = ppv.project_id ;
506:
507:

Line 504: AND pa_structure_types.structure_type = 'FINANCIAL'

500: AND ppv.object_type = 'PA_TASKS'
501: AND str_ver.project_id = l_project_id
502: AND str_ver.proj_element_id = str_type.proj_element_id
503: AND str_type.structure_type_id = pa_structure_types.structure_type_id
504: AND pa_structure_types.structure_type = 'FINANCIAL'
505: AND pae.project_id = ppv.project_id ;
506:
507:
508: BEGIN

Line 940: , pa_structure_types

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
944: AND ppv.proj_element_id = pae.proj_element_id

Line 950: AND str_type.structure_type_id = pa_structure_types.structure_type_id

946: AND pae.object_type = 'PA_TASKS'
947: AND ppv.object_type = 'PA_TASKS'
948: AND str_ver.project_id = l_project_id
949: AND str_ver.proj_element_id = str_type.proj_element_id
950: AND str_type.structure_type_id = pa_structure_types.structure_type_id
951: AND pa_structure_types.structure_type = 'FINANCIAL'
952: AND ppv.project_id = pae.project_id;
953:
954: BEGIN

Line 951: AND pa_structure_types.structure_type = 'FINANCIAL'

947: AND ppv.object_type = 'PA_TASKS'
948: AND str_ver.project_id = l_project_id
949: AND str_ver.proj_element_id = str_type.proj_element_id
950: AND str_type.structure_type_id = pa_structure_types.structure_type_id
951: AND pa_structure_types.structure_type = 'FINANCIAL'
952: AND ppv.project_id = pae.project_id;
953:
954: BEGIN
955:

Line 1354: pa_structure_types pstrType

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
1358: pelever.project_id = l_dest_project_id

Line 1820: -- , pa_structure_types strType Bug 3693235 Performance Fix

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'
1824: AND elever1.parent_structure_version_id = elever2.element_version_id