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.EGO_ITEM_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 3771: FROM PA_PROJ_ELEMENT_VERSIONS P1

3767: AND rev.revision_id = cp_revision_id; --changed =rev.revision_id to cp_revision_id bug 7324207
3768:
3769: CURSOR c_get_phase_seq (cp_phase_id IN NUMBER ) IS
3770: SELECT p1.display_sequence
3771: FROM PA_PROJ_ELEMENT_VERSIONS P1
3772: WHERE P1.PROJ_ELEMENT_ID = cp_phase_id;
3773:
3774: CURSOR c_get_next_phase (cp_lifecycle_id IN NUMBER
3775: ,cp_phase_id IN NUMBER ) IS

Line 3777: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2

3773:
3774: CURSOR c_get_next_phase (cp_lifecycle_id IN NUMBER
3775: ,cp_phase_id IN NUMBER ) IS
3776: SELECT p1.proj_element_id, p1.display_sequence
3777: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2
3778: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3779: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3780: AND P1.display_sequence >
3781: (SELECT P3.display_sequence

Line 3782: FROM PA_PROJ_ELEMENT_VERSIONS P3

3778: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3779: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3780: AND P1.display_sequence >
3781: (SELECT P3.display_sequence
3782: FROM PA_PROJ_ELEMENT_VERSIONS P3
3783: WHERE P3.PROJ_ELEMENT_ID = cp_phase_id
3784: AND P3.PARENT_STRUCTURE_VERSION_ID = P1.parent_structure_version_id
3785: )
3786: ORDER BY p1.DISPLAY_SEQUENCE ASC;

Line 3791: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2

3787:
3788: CURSOR c_get_priv_phase (cp_lifecycle_id IN NUMBER
3789: ,cp_phase_id IN NUMBER ) IS
3790: SELECT p1.proj_element_id, p1.display_sequence
3791: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2
3792: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3793: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3794: AND P1.display_sequence <
3795: (SELECT P3.display_sequence

Line 3796: FROM PA_PROJ_ELEMENT_VERSIONS P3

3792: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
3793: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
3794: AND P1.display_sequence <
3795: (SELECT P3.display_sequence
3796: FROM PA_PROJ_ELEMENT_VERSIONS P3
3797: WHERE P3.PROJ_ELEMENT_ID = cp_phase_id
3798: AND P3.PARENT_STRUCTURE_VERSION_ID = P1.parent_structure_version_id
3799: )
3800: ORDER BY p1.DISPLAY_SEQUENCE DESC;