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 1795: -- PA_OBJECT_RELATIONSHIPS

1791: -- *** This API assumes that the following tables exist and that they are
1792: -- properly populated (no cycles, correct relationships, etc)
1793: --
1794: -- PA_PROJ_ELEMENT_VERSIONS
1795: -- PA_OBJECT_RELATIONSHIPS
1796: --
1797: -- Then, this API populates output values in the following existing
1798: -- table:
1799: -- PJI_FP_AGGR_XBS

Line 2145: from PA_OBJECT_RELATIONSHIPS prt_parent,

2141: distinct
2142: prt_parent.object_id_from1,
2143: prt_parent.relationship_type,
2144: ver.prg_level
2145: from PA_OBJECT_RELATIONSHIPS prt_parent,
2146: PA_PROJ_ELEMENT_VERSIONS ver
2147: where 1=1
2148: and prt_parent.object_id_to1 = PRG_NODE.element_version_id
2149: and prt_parent.object_type_from = 'PA_TASKS'

Line 2186: from pa_object_relationships dt_rel,

2182: else
2183: /*
2184: select dt_ver1.proj_element_id
2185: into l_prg_temp_rollup
2186: from pa_object_relationships dt_rel,
2187: pa_proj_element_versions dt_ver1,
2188: pa_proj_element_versions dt_ver2
2189: where 1=1
2190: and dt_ver1.element_version_id = dt_rel.object_id_from1

Line 2200: from pa_object_relationships dt_rel,

2196:
2197: -- Bug 3838523
2198: select dt_ver1.proj_element_id
2199: into l_prg_temp_rollup
2200: from pa_object_relationships dt_rel,
2201: pa_proj_element_versions dt_ver1
2202: where 1=1
2203: and dt_ver1.element_version_id = dt_rel.object_id_from1
2204: and dt_rel.object_type_from = 'PA_TASKS'

Line 2521: -- PA_OBJECT_RELATIONSHIPS

2517: -- *** This API assumes that the following tables exist and that they are
2518: -- properly populated (no cycles, correct relationships, etc)
2519: --
2520: -- PA_PROJ_ELEMENT_VERSIONS
2521: -- PA_OBJECT_RELATIONSHIPS
2522: --
2523: -- Then, this API populates output values in the following existing
2524: -- table:
2525: -- PJI_FP_AGGR_XBS

Line 2759: from PA_OBJECT_RELATIONSHIPS wrt_parent

2755:
2756: -- l_wbs_temp_parent --
2757: select wrt_parent.object_id_from1
2758: into l_wbs_temp_parent
2759: from PA_OBJECT_RELATIONSHIPS wrt_parent
2760: where 1=1
2761: and wrt_parent.object_id_to1 = WBS_NODE.element_version_id
2762: and wrt_parent.object_type_from = 'PA_TASKS'
2763: and wrt_parent.object_type_to = 'PA_TASKS'

Line 3090: -- PA_OBJECT_RELATIONSHIPS

3086: -- *** This API assumes that the following tables exist and that they are
3087: -- properly populated (no cycles, correct relationships, etc)
3088: --
3089: -- PA_PROJ_ELEMENT_VERSIONS
3090: -- PA_OBJECT_RELATIONSHIPS
3091: --
3092: -- Then, this API populates output values in the following existing
3093: -- table:
3094: -- PJI_FP_AGGR_XBS

Line 3333: from PA_OBJECT_RELATIONSHIPS prt_parent,

3329: distinct
3330: prt_parent.object_id_from1,
3331: prt_parent.relationship_type,
3332: ver.prg_level
3333: from PA_OBJECT_RELATIONSHIPS prt_parent,
3334: PA_PROJ_ELEMENT_VERSIONS ver
3335: where 1=1
3336: and prt_parent.object_id_to1 = PRG_NODE.element_version_id
3337: and prt_parent.object_type_from = 'PA_TASKS'

Line 3376: from pa_object_relationships dt_rel,

3372:
3373: else
3374: select dt_ver1.proj_element_id
3375: into l_prg_temp_rollup
3376: from pa_object_relationships dt_rel,
3377: pa_proj_element_versions dt_ver1
3378: /* commented for bug 3838523 pa_proj_element_versions dt_ver2*/
3379: where 1=1
3380: and dt_ver1.element_version_id = dt_rel.object_id_from1

Line 3659: -- PA_OBJECT_RELATIONSHIPS

3655: -- *** This API assumes that the following tables exist and that they are
3656: -- properly populated (no cycles, correct relationships, etc)
3657: --
3658: -- PA_PROJ_ELEMENT_VERSIONS
3659: -- PA_OBJECT_RELATIONSHIPS
3660: --
3661: -- Then, this API populates output values in the following existing
3662: -- table:
3663: -- PJI_FP_AGGR_XBS_T

Line 3972: from PA_OBJECT_RELATIONSHIPS rel,

3968: -- have appeared with corrupted data
3969:
3970: select count(*) -- ###parent_is_one###
3971: into l_wbs_test_node
3972: from PA_OBJECT_RELATIONSHIPS rel,
3973: (
3974: select element_version_id
3975: from PA_PROJ_ELEMENT_VERSIONS
3976: where 1=1

Line 3998: from PA_OBJECT_RELATIONSHIPS wrt_parent

3994:
3995: -- l_wbs_temp_parent --
3996: select wrt_parent.object_id_from1
3997: into l_wbs_temp_parent
3998: from PA_OBJECT_RELATIONSHIPS wrt_parent
3999: where 1=1
4000: and wrt_parent.object_id_to1 = WBS_NODE.element_version_id
4001: and wrt_parent.object_type_from = 'PA_TASKS'
4002: and wrt_parent.object_type_to = 'PA_TASKS'