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_WORKPLAN_ATTR

Line 8898: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
8902: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 8988: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
8992: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 10981: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
10985: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 11071: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
11075: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 12719: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
12723: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 13341: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
13345: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 14509: PA_PROJ_WORKPLAN_ATTR sup_wpa,

14505: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 15058: PA_PROJ_WORKPLAN_ATTR sup_wpa,

15054: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,