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 1466: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

1462: -- Commenting and adding code for testing 0802
1463: --PJI_PJP_WBS_HEADER wbs_hdr,
1464: PJI_PJP_WBS_HEADER_T wbs_hdr,
1465: -- End of Commenting and adding code for testing 0802
1466: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
1467: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
1468: PA_PROJ_WORKPLAN_ATTR sup_wpa
1469: where
1470: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 1467: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

1463: --PJI_PJP_WBS_HEADER wbs_hdr,
1464: PJI_PJP_WBS_HEADER_T wbs_hdr,
1465: -- End of Commenting and adding code for testing 0802
1466: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
1467: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
1468: PA_PROJ_WORKPLAN_ATTR sup_wpa
1469: where
1470: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
1471: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 1557: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

1553: -4, pjp.PLAN_TYPE_ID,
1554: wbs_hdr.PLAN_TYPE_ID)),
1555: pjp.PLAN_TYPE_CODE
1556: ) pjp1_i,
1557: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
1558: PA_PROJ_WORKPLAN_ATTR sup_wpa
1559: where
1560: pjp1_i.INSERT_FLAG = 'Y' and
1561: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 2840: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

2836: -1 = prg_delta.SIGN (+) and
2837: prg_delta.SUP_PROJECT_ID is null
2838: ) prg,
2839: PJI_PJP_WBS_HEADER wbs_hdr,
2840: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2841: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2842: PA_PROJ_WORKPLAN_ATTR sup_wpa
2843: where
2844: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 2841: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

2837: prg_delta.SUP_PROJECT_ID is null
2838: ) prg,
2839: PJI_PJP_WBS_HEADER wbs_hdr,
2840: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2841: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2842: PA_PROJ_WORKPLAN_ATTR sup_wpa
2843: where
2844: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
2845: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 2931: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

2927: -4, pjp.PLAN_TYPE_ID,
2928: wbs_hdr.PLAN_TYPE_ID)),
2929: pjp.PLAN_TYPE_CODE
2930: ) pjp1_i,
2931: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
2932: PA_PROJ_WORKPLAN_ATTR sup_wpa
2933: where
2934: pjp1_i.INSERT_FLAG = 'Y' and
2935: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 8514: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where

8510: fpo.FIN_PLAN_TYPE_ID <> l_workplan_type_id and -- Bug# 5208322
8511: 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'
8512: )
8513: 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
8514: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where
8515: bv.FIN_PLAN_TYPE_ID = l_workplan_type_id and -- Bug# 5208322
8516: bv.PROJECT_STRUCTURE_VERSION_ID = ppevs.ELEMENT_VERSION_ID and
8517: (
8518: decode(BITAND(l_refresh_code,g_all_plans),g_all_plans,'N',

Line 13095: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

13091: prg.SUP_LEVEL, 'A',
13092: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
13093: ) prg,
13094: PJI_PJP_WBS_HEADER wbs_hdr,
13095: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
13096: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
13097: PA_PROJ_WORKPLAN_ATTR sup_wpa
13098: where
13099: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 13096: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

13092: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
13093: ) prg,
13094: PJI_PJP_WBS_HEADER wbs_hdr,
13095: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
13096: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
13097: PA_PROJ_WORKPLAN_ATTR sup_wpa
13098: where
13099: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
13100: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 13186: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

13182: -4, pjp.PLAN_TYPE_ID,
13183: wbs_hdr.PLAN_TYPE_ID)),
13184: pjp.PLAN_TYPE_CODE
13185: ) pjp1_i,
13186: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
13187: PA_PROJ_WORKPLAN_ATTR sup_wpa
13188: where
13189: pjp1_i.INSERT_FLAG = 'Y' and
13190: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 14838: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

14834: pjp.PRG_ROLLUP_FLAG, 'Y'),
14835: pjp.CURR_RECORD_TYPE_ID,
14836: pjp.CURRENCY_CODE
14837: ) pjp1_i,
14838: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
14839: PA_PROJ_WORKPLAN_ATTR sup_wpa
14840: where
14841: pjp1_i.INSERT_FLAG = 'Y' and
14842: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 15460: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

15456: pjp.PRG_ROLLUP_FLAG, 'Y'),
15457: pjp.CURR_RECORD_TYPE_ID,
15458: pjp.CURRENCY_CODE
15459: ) pjp1_i,
15460: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
15461: PA_PROJ_WORKPLAN_ATTR sup_wpa
15462: where
15463: pjp1_i.INSERT_FLAG = 'Y' and
15464: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 16137: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

16133: PA_PROJ_ELEMENTS prj_emt,
16134: PJI_PJP_WBS_HEADER wbs_hdr,
16135: PJI_FP_XBS_ACCUM_F fpr,
16136: PJI_PJP_WBS_HEADER sup_wbs_hdr,
16137: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16138: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16139: (
16140: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16141: from DUAL union all

Line 16138: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

16134: PJI_PJP_WBS_HEADER wbs_hdr,
16135: PJI_FP_XBS_ACCUM_F fpr,
16136: PJI_PJP_WBS_HEADER sup_wbs_hdr,
16137: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16138: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16139: (
16140: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16141: from DUAL union all
16142: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 16538: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

16534: PA_PROJ_ELEMENTS prj_emt,
16535: PA_XBS_DENORM prg,
16536: PJI_XBS_DENORM_DELTA prg_delta,
16537: PJI_PJP_WBS_HEADER sup_wbs_hdr,
16538: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16539: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16540: (
16541: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16542: from DUAL union all

Line 16539: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

16535: PA_XBS_DENORM prg,
16536: PJI_XBS_DENORM_DELTA prg_delta,
16537: PJI_PJP_WBS_HEADER sup_wbs_hdr,
16538: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16539: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16540: (
16541: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16542: from DUAL union all
16543: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 16634: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

16630: wbs_hdr.CO_FLAG = fin_plan.CO (+)
16631: ) pjp,
16632: PJI_PJP_PROJ_BATCH_MAP map,
16633: PA_PROJ_WORKPLAN_ATTR sup_wpa,
16634: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
16635: PA_XBS_DENORM wbs,
16636: (
16637: select 1 WBS_SUP_LEVEL,
16638: 'PRJ' INVERT_ID

Line 17188: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

17184: wbs_hdr.PLAN_VERSION_ID = -1
17185: ) pjp,
17186: PJI_PJP_PROJ_BATCH_MAP map,
17187: PA_PROJ_WORKPLAN_ATTR sup_wpa,
17188: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
17189: PA_XBS_DENORM wbs,
17190: (
17191: select 1 WBS_SUP_LEVEL,
17192: 'PRJ' INVERT_ID

Line 19586: pa_proj_elem_ver_structure str

19582: FROM
19583: pji_pjp_proj_batch_map map,
19584: pa_proj_element_versions ver,
19585: pa_proj_structure_types typ,
19586: pa_proj_elem_ver_structure str
19587: WHERE
19588: typ.STRUCTURE_TYPE_ID = 1
19589: AND typ.PROJ_ELEMENT_ID = str.PROJ_ELEMENT_ID
19590: AND str.LATEST_EFF_PUBLISHED_FLAG = 'Y'