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_ROLLUP dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 5236: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where

5232: fpo.FIN_PLAN_TYPE_ID <> l_workplan_type_id and -- Bug# 5208322
5233: DECODE(BITAND(l_refresh_code,g_all_plans),g_all_plans,'N',DECODE(BITAND(l_refresh_code,g_wk_plans),g_wk_plans,'Y','N'))='Y'
5234: )
5235: OR --Pull Reversals for Work plan Working Versions / LPub Vers / Baselined Versions when l_refresh_code=2,8,16,30. ignore if l_refresh_code>=62
5236: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where
5237: bv.FIN_PLAN_TYPE_ID = l_workplan_type_id and -- Bug# 5208322
5238: bv.PROJECT_STRUCTURE_VERSION_ID = ppevs.ELEMENT_VERSION_ID and
5239: (
5240: decode(BITAND(l_refresh_code,g_all_plans),g_all_plans,'N',

Line 8896: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

8892: -1 = prg_delta.SIGN (+) and
8893: prg_delta.SUP_PROJECT_ID is null
8894: ) prg,
8895: PJI_PJP_WBS_HEADER wbs_hdr,
8896: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8897: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8898: PA_PROJ_WORKPLAN_ATTR sup_wpa
8899: where
8900: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 8897: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

8893: prg_delta.SUP_PROJECT_ID is null
8894: ) prg,
8895: PJI_PJP_WBS_HEADER wbs_hdr,
8896: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8897: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8898: PA_PROJ_WORKPLAN_ATTR sup_wpa
8899: where
8900: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
8901: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 8987: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

8983: -4, pjp.PLAN_TYPE_ID,
8984: wbs_hdr.PLAN_TYPE_ID)),
8985: pjp.PLAN_TYPE_CODE
8986: ) pjp1_i,
8987: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
8988: PA_PROJ_WORKPLAN_ATTR sup_wpa
8989: where
8990: pjp1_i.INSERT_FLAG = 'Y' and
8991: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 10979: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

10975: prg.SUP_LEVEL, 'A',
10976: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
10977: ) prg,
10978: PJI_PJP_WBS_HEADER wbs_hdr,
10979: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10980: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10981: PA_PROJ_WORKPLAN_ATTR sup_wpa
10982: where
10983: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 10980: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

10976: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
10977: ) prg,
10978: PJI_PJP_WBS_HEADER wbs_hdr,
10979: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10980: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10981: PA_PROJ_WORKPLAN_ATTR sup_wpa
10982: where
10983: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
10984: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 11070: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

11066: -4, pjp.PLAN_TYPE_ID,
11067: wbs_hdr.PLAN_TYPE_ID)),
11068: pjp.PLAN_TYPE_CODE
11069: ) pjp1_i,
11070: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
11071: PA_PROJ_WORKPLAN_ATTR sup_wpa
11072: where
11073: pjp1_i.INSERT_FLAG = 'Y' and
11074: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 12718: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

12714: pjp.PRG_ROLLUP_FLAG, 'Y'),
12715: pjp.CURR_RECORD_TYPE_ID,
12716: pjp.CURRENCY_CODE
12717: ) pjp1_i,
12718: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
12719: PA_PROJ_WORKPLAN_ATTR sup_wpa
12720: where
12721: pjp1_i.INSERT_FLAG = 'Y' and
12722: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 13340: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

13336: pjp.PRG_ROLLUP_FLAG, 'Y'),
13337: pjp.CURR_RECORD_TYPE_ID,
13338: pjp.CURRENCY_CODE
13339: ) pjp1_i,
13340: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
13341: PA_PROJ_WORKPLAN_ATTR sup_wpa
13342: where
13343: pjp1_i.INSERT_FLAG = 'Y' and
13344: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 14013: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

14009: PA_PROJ_ELEMENTS prj_emt,
14010: PJI_PJP_WBS_HEADER wbs_hdr,
14011: PJI_FP_XBS_ACCUM_F fpr,
14012: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14013: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14014: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14015: (
14016: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14017: from DUAL union all

Line 14014: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

14010: PJI_PJP_WBS_HEADER wbs_hdr,
14011: PJI_FP_XBS_ACCUM_F fpr,
14012: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14013: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14014: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14015: (
14016: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14017: from DUAL union all
14018: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 14414: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

14410: PA_PROJ_ELEMENTS prj_emt,
14411: PA_XBS_DENORM prg,
14412: PJI_XBS_DENORM_DELTA prg_delta,
14413: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14414: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14415: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14416: (
14417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14418: from DUAL union all

Line 14415: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

14411: PA_XBS_DENORM prg,
14412: PJI_XBS_DENORM_DELTA prg_delta,
14413: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14414: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14415: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14416: (
14417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14418: from DUAL union all
14419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 14510: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

14506: wbs_hdr.CO_FLAG = fin_plan.CO (+)
14507: ) pjp,
14508: PJI_PJP_PROJ_BATCH_MAP map,
14509: PA_PROJ_WORKPLAN_ATTR sup_wpa,
14510: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
14511: PA_XBS_DENORM wbs,
14512: (
14513: select 1 WBS_SUP_LEVEL,
14514: 'PRJ' INVERT_ID

Line 15059: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

15055: wbs_hdr.PLAN_VERSION_ID = -1
15056: ) pjp,
15057: PJI_PJP_PROJ_BATCH_MAP map,
15058: PA_PROJ_WORKPLAN_ATTR sup_wpa,
15059: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
15060: PA_XBS_DENORM wbs,
15061: (
15062: select 1 WBS_SUP_LEVEL,
15063: 'PRJ' INVERT_ID

Line 17303: pa_proj_elem_ver_structure str

17299: FROM
17300: pji_pjp_proj_batch_map map,
17301: pa_proj_element_versions ver,
17302: pa_proj_structure_types typ,
17303: pa_proj_elem_ver_structure str
17304: WHERE
17305: typ.STRUCTURE_TYPE_ID = 1
17306: AND typ.PROJ_ELEMENT_ID = str.PROJ_ELEMENT_ID
17307: AND str.LATEST_EFF_PUBLISHED_FLAG = 'Y'