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_DELIVERABLE_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 1909: ,PA_PROJ_ELEM_VER_SCHEDULE PES

1905: PES.SCHEDULED_FINISH_DATE,
1906: SYSDATE
1907: FROM
1908: PA_PROJ_ELEMENT_VERSIONS PEV
1909: ,PA_PROJ_ELEM_VER_SCHEDULE PES
1910: WHERE
1911: PEV.ELEMENT_VERSION_ID = p_task_ver_id
1912: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;
1913:

Line 1916: This Query was flagged by xpl utility because of missing index PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m 3614361 */

1912: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;
1913:
1914: /* AND PEV.OBJECT_TYPE = 'PA_TASKS'
1915: AND PES.PROJECT_ID = p_project_id;Commented Unnecessary joins -
1916: This Query was flagged by xpl utility because of missing index PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m 3614361 */
1917:
1918: BEGIN
1919:
1920: IF p_task_ver_id IS NOT NULL THEN

Line 2073: PA_PROJ_ELEM_VER_SCHEDULE PES

2069: PES.SCHEDULED_FINISH_DATE,
2070: SYSDATE
2071: FROM
2072: PA_PROJ_ELEMENT_VERSIONS PEV,
2073: PA_PROJ_ELEM_VER_SCHEDULE PES
2074: WHERE
2075: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
2076: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;
2077:

Line 2081: PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m database Bug 3614361 */

2077:
2078: /* AND PEV.OBJECT_TYPE = 'PA_DELIVERABLES'
2079: AND PEV.PROJECT_ID = PES.PROJECT_ID;
2080: Commented Unwanted Joins - This query was flagged by xpl utility because of missing index
2081: PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m database Bug 3614361 */
2082:
2083: CURSOR l_task_date_info_csr
2084: IS
2085: SELECT

Line 2091: ,PA_PROJ_ELEM_VER_SCHEDULE PES

2087: ,PES.EARLY_FINISH_DATE
2088: ,PES.SCHEDULED_FINISH_DATE
2089: FROM
2090: PA_PROJ_ELEMENT_VERSIONS PEV
2091: ,PA_PROJ_ELEM_VER_SCHEDULE PES
2092: WHERE
2093: PEV.ELEMENT_VERSION_ID = p_task_ver_id
2094: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;
2095:

Line 2099: PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m database Bug 3614361 */

2095:
2096: /* AND PEV.OBJECT_TYPE = 'PA_TASKS'
2097: AND PEV.PROJECT_ID = PES.PROJECT_ID;
2098: Commented Unwanted Joins - This query was flagged by xpl utility because of missing index
2099: PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m database Bug 3614361 */
2100: BEGIN
2101:
2102: OPEN l_proj_date_info_csr;
2103: FETCH l_proj_date_info_csr INTO l_scheduled_finish_date, l_sysdate;

Line 2571: PA_PROJ_ELEM_VER_SCHEDULE PES

2567: PES.SCHEDULED_FINISH_DATE,
2568: SYSDATE
2569: FROM
2570: PA_PROJ_ELEMENT_VERSIONS PEV,
2571: PA_PROJ_ELEM_VER_SCHEDULE PES
2572: WHERE
2573: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
2574: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID
2575: AND PEV.OBJECT_TYPE = 'PA_DELIVERABLES'

Line 2586: ,PA_PROJ_ELEM_VER_SCHEDULE PES

2582: ,PES.EARLY_FINISH_DATE
2583: ,PES.SCHEDULED_FINISH_DATE
2584: FROM
2585: PA_PROJ_ELEMENT_VERSIONS PEV
2586: ,PA_PROJ_ELEM_VER_SCHEDULE PES
2587: WHERE
2588: PEV.ELEMENT_VERSION_ID = p_task_ver_id
2589: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID
2590: AND PEV.OBJECT_TYPE = 'PA_TASKS'

Line 5390: PA_PROJ_ELEM_VER_SCHEDULE

5386: ,ACTUAL_FINISH_DATE
5387: ,EARLY_START_DATE
5388: ,EARLY_FINISH_DATE
5389: FROM
5390: PA_PROJ_ELEM_VER_SCHEDULE
5391: WHERE
5392: ELEMENT_VERSION_ID = l_task_ver_id ;
5393:
5394: /*AND PROJECT_ID = p_project_id Commented Unwanted Join 3614361 */

Line 5988: p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE

5984: -- x_bill_description VARCHAR2 Billing Action Description
5985:
5986: PROCEDURE GET_BILLING_DETAILS
5987: (
5988: p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
5989: ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
5990: ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895
5991: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5992: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5989: ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895

5985:
5986: PROCEDURE GET_BILLING_DETAILS
5987: (
5988: p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
5989: ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
5990: ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895
5991: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5992: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5993: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 6003: PA_PROJ_ELEM_VER_SCHEDULE PES

5999: PPE.DESCRIPTION
6000: ,PES.ACTUAL_FINISH_DATE
6001: FROM
6002: PA_PROJ_ELEMENTS PPE,
6003: PA_PROJ_ELEM_VER_SCHEDULE PES
6004: WHERE
6005: PES.ELEMENT_VERSION_ID = p_action_version_id
6006: AND PES.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
6007: AND PPE.OBJECT_TYPE = 'PA_ACTIONS'

Line 6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895

6180: (
6181: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
6182: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6186: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6187: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6188: )

Line 6187: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895

6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6186: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6187: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6188: )
6189: IS
6190:
6191: CURSOR l_ship_info_csr

Line 6200: ,pa_proj_elem_ver_schedule ppevs

6196: ,ppevs.scheduled_finish_date
6197: from
6198: pa_object_relationships obj
6199: ,pa_proj_elements ppe
6200: ,pa_proj_elem_ver_schedule ppevs
6201: ,pa_proj_element_versions pev
6202: where
6203: pev.element_version_id = p_dlvr_id
6204: and obj.object_id_from2 = pev.proj_element_id

Line 6224: ,pa_proj_elem_ver_schedule ppevs

6220: ,ppevs.scheduled_finish_date
6221: from
6222: pa_object_relationships obj
6223: ,pa_proj_elements ppe
6224: ,pa_proj_elem_ver_schedule ppevs
6225: ,pa_proj_element_versions pev
6226: where
6227: pev.element_version_id = p_dlvr_id
6228: and obj.object_id_from2 = pev.proj_element_id