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.PJI_PJP_SUM_DENORM dependencies on PA_OBJECT_RELATIONSHIPS

Line 1855: -- PA_OBJECT_RELATIONSHIPS

1851: -- *** This API assumes that the following tables exist and that they are
1852: -- properly populated (no cycles, correct relationships, etc)
1853: --
1854: -- PA_PROJ_ELEMENT_VERSIONS
1855: -- PA_OBJECT_RELATIONSHIPS
1856: --
1857: -- Then, this API populates output values in the following existing
1858: -- table:
1859: -- PJI_FP_AGGR_XBS

Line 2205: from PA_OBJECT_RELATIONSHIPS prt_parent,

2201: distinct
2202: prt_parent.object_id_from1,
2203: prt_parent.relationship_type,
2204: ver.prg_level
2205: from PA_OBJECT_RELATIONSHIPS prt_parent,
2206: PA_PROJ_ELEMENT_VERSIONS ver
2207: where 1=1
2208: and prt_parent.object_id_to1 = PRG_NODE.element_version_id
2209: and prt_parent.object_type_from = 'PA_TASKS'

Line 2246: from pa_object_relationships dt_rel,

2242: else
2243: /*
2244: select dt_ver1.proj_element_id
2245: into l_prg_temp_rollup
2246: from pa_object_relationships dt_rel,
2247: pa_proj_element_versions dt_ver1,
2248: pa_proj_element_versions dt_ver2
2249: where 1=1
2250: and dt_ver1.element_version_id = dt_rel.object_id_from1

Line 2260: from pa_object_relationships dt_rel,

2256:
2257: -- Bug 3838523
2258: select dt_ver1.proj_element_id
2259: into l_prg_temp_rollup
2260: from pa_object_relationships dt_rel,
2261: pa_proj_element_versions dt_ver1
2262: where 1=1
2263: and dt_ver1.element_version_id = dt_rel.object_id_from1
2264: and dt_rel.object_type_from = 'PA_TASKS'

Line 2581: -- PA_OBJECT_RELATIONSHIPS

2577: -- *** This API assumes that the following tables exist and that they are
2578: -- properly populated (no cycles, correct relationships, etc)
2579: --
2580: -- PA_PROJ_ELEMENT_VERSIONS
2581: -- PA_OBJECT_RELATIONSHIPS
2582: --
2583: -- Then, this API populates output values in the following existing
2584: -- table:
2585: -- PJI_FP_AGGR_XBS

Line 2824: from PA_OBJECT_RELATIONSHIPS wrt_parent

2820:
2821: -- l_wbs_temp_parent --
2822: select wrt_parent.object_id_from1
2823: into l_wbs_temp_parent
2824: from PA_OBJECT_RELATIONSHIPS wrt_parent
2825: where 1=1
2826: and wrt_parent.object_id_to1 = WBS_NODE.element_version_id
2827: and wrt_parent.object_type_from = 'PA_TASKS'
2828: and wrt_parent.object_type_to = 'PA_TASKS'

Line 3155: -- PA_OBJECT_RELATIONSHIPS

3151: -- *** This API assumes that the following tables exist and that they are
3152: -- properly populated (no cycles, correct relationships, etc)
3153: --
3154: -- PA_PROJ_ELEMENT_VERSIONS
3155: -- PA_OBJECT_RELATIONSHIPS
3156: --
3157: -- Then, this API populates output values in the following existing
3158: -- table:
3159: -- PJI_FP_AGGR_XBS

Line 3398: from PA_OBJECT_RELATIONSHIPS prt_parent,

3394: distinct
3395: prt_parent.object_id_from1,
3396: prt_parent.relationship_type,
3397: ver.prg_level
3398: from PA_OBJECT_RELATIONSHIPS prt_parent,
3399: PA_PROJ_ELEMENT_VERSIONS ver
3400: where 1=1
3401: and prt_parent.object_id_to1 = PRG_NODE.element_version_id
3402: and prt_parent.object_type_from = 'PA_TASKS'

Line 3441: from pa_object_relationships dt_rel,

3437:
3438: else
3439: select dt_ver1.proj_element_id
3440: into l_prg_temp_rollup
3441: from pa_object_relationships dt_rel,
3442: pa_proj_element_versions dt_ver1
3443: /* commented for bug 3838523 pa_proj_element_versions dt_ver2*/
3444: where 1=1
3445: and dt_ver1.element_version_id = dt_rel.object_id_from1

Line 3724: -- PA_OBJECT_RELATIONSHIPS

3720: -- *** This API assumes that the following tables exist and that they are
3721: -- properly populated (no cycles, correct relationships, etc)
3722: --
3723: -- PA_PROJ_ELEMENT_VERSIONS
3724: -- PA_OBJECT_RELATIONSHIPS
3725: --
3726: -- Then, this API populates output values in the following existing
3727: -- table:
3728: -- PJI_FP_AGGR_XBS_T

Line 4037: from PA_OBJECT_RELATIONSHIPS rel,

4033: -- have appeared with corrupted data
4034:
4035: select count(*) -- ###parent_is_one###
4036: into l_wbs_test_node
4037: from PA_OBJECT_RELATIONSHIPS rel,
4038: (
4039: select element_version_id
4040: from PA_PROJ_ELEMENT_VERSIONS
4041: where 1=1

Line 4063: from PA_OBJECT_RELATIONSHIPS wrt_parent

4059:
4060: -- l_wbs_temp_parent --
4061: select wrt_parent.object_id_from1
4062: into l_wbs_temp_parent
4063: from PA_OBJECT_RELATIONSHIPS wrt_parent
4064: where 1=1
4065: and wrt_parent.object_id_to1 = WBS_NODE.element_version_id
4066: and wrt_parent.object_type_from = 'PA_TASKS'
4067: and wrt_parent.object_type_to = 'PA_TASKS'