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.

[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1448: FROM pa_proj_element_versions pev_l

1444: CURSOR c_Get_Lifecyle_Phase (
1445: p_lifecycle_id NUMBER
1446: ) IS
1447: SELECT pev_p.proj_element_id
1448: FROM pa_proj_element_versions pev_l
1449: ,pa_lifecycle_usages plu
1450: ,pa_proj_element_versions pev_p
1451: ,pa_proj_elements ppe_p
1452: ,pa_project_statuses pc

Line 1450: ,pa_proj_element_versions pev_p

1446: ) IS
1447: SELECT pev_p.proj_element_id
1448: FROM pa_proj_element_versions pev_l
1449: ,pa_lifecycle_usages plu
1450: ,pa_proj_element_versions pev_p
1451: ,pa_proj_elements ppe_p
1452: ,pa_project_statuses pc
1453: WHERE pev_l.object_type = 'PA_STRUCTURES'
1454: AND pev_l.proj_element_id = p_lifecycle_id

Line 1585: FROM PA_PROJ_ELEMENT_VERSIONS pev_l,

1581: AND organization_id = cp_org_id;
1582:
1583: /* CURSOR c_get_default_phase_id (cp_lifecycle_id IN NUMBER) IS
1584: SELECT pev_p.PROJ_ELEMENT_ID
1585: FROM PA_PROJ_ELEMENT_VERSIONS pev_l,
1586: PA_LIFECYCLE_USAGES plu,
1587: PA_PROJ_ELEMENT_VERSIONS pev_p,
1588: PA_PROJ_ELEMENTS PPE_P,
1589: PA_PROJECT_STATUSES pc

Line 1587: PA_PROJ_ELEMENT_VERSIONS pev_p,

1583: /* CURSOR c_get_default_phase_id (cp_lifecycle_id IN NUMBER) IS
1584: SELECT pev_p.PROJ_ELEMENT_ID
1585: FROM PA_PROJ_ELEMENT_VERSIONS pev_l,
1586: PA_LIFECYCLE_USAGES plu,
1587: PA_PROJ_ELEMENT_VERSIONS pev_p,
1588: PA_PROJ_ELEMENTS PPE_P,
1589: PA_PROJECT_STATUSES pc
1590: WHERE pev_l.OBJECT_TYPE = 'PA_STRUCTURES'
1591: AND pev_l.PROJ_ELEMENT_ID = cp_lifecycle_id

Line 3630: FROM pa_proj_element_versions

3626: AND organization_id = cp_org_id;
3627:
3628: CURSOR c_get_phase_seq (cp_phase_id IN NUMBER ) IS
3629: SELECT display_sequence
3630: FROM pa_proj_element_versions
3631: WHERE proj_element_id = cp_phase_id;
3632:
3633: CURSOR c_get_next_phase (cp_lifecycle_id IN NUMBER
3634: ,cp_phase_id IN NUMBER ) IS

Line 3636: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2

3632:
3633: CURSOR c_get_next_phase (cp_lifecycle_id IN NUMBER
3634: ,cp_phase_id IN NUMBER ) IS
3635: SELECT p1.proj_element_id, p1.display_sequence
3636: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2
3637: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3638: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3639: AND P1.display_sequence >
3640: (SELECT P3.display_sequence

Line 3641: FROM PA_PROJ_ELEMENT_VERSIONS P3

3637: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3638: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3639: AND P1.display_sequence >
3640: (SELECT P3.display_sequence
3641: FROM PA_PROJ_ELEMENT_VERSIONS P3
3642: WHERE P3.PROJ_ELEMENT_ID = cp_phase_id
3643: AND P3.PARENT_STRUCTURE_VERSION_ID = P1.parent_structure_version_id
3644: )
3645: ORDER BY p1.DISPLAY_SEQUENCE ASC;

Line 3650: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2

3646:
3647: CURSOR c_get_priv_phase (cp_lifecycle_id IN NUMBER
3648: ,cp_phase_id IN NUMBER ) IS
3649: SELECT p1.proj_element_id, p1.display_sequence
3650: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2
3651: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3652: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3653: AND P1.display_sequence <
3654: (SELECT P3.display_sequence

Line 3655: FROM PA_PROJ_ELEMENT_VERSIONS P3

3651: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3652: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3653: AND P1.display_sequence <
3654: (SELECT P3.display_sequence
3655: FROM PA_PROJ_ELEMENT_VERSIONS P3
3656: WHERE P3.PROJ_ELEMENT_ID = cp_phase_id
3657: AND P3.PARENT_STRUCTURE_VERSION_ID = P1.parent_structure_version_id
3658: )
3659: ORDER BY p1.DISPLAY_SEQUENCE DESC;