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.

[Home] [Help]

APPS.PJI_PJP_GEN_PERF_ALL dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 433: , PA_PROJ_ELEM_VER_STRUCTURE pevs

429: PJI_FM_EXTR_PLNVER4 ver
430: , PA_RESOURCE_ASSIGNMENTS ra
431: , PA_BUDGET_LINES bl
432: , PA_PROJECTS_ALL ppa
433: , PA_PROJ_ELEM_VER_STRUCTURE pevs
434: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
435: AND ((( p_slice_type = 'PRI' )
436: AND (( ver.wp_flag = 'Y' )OR (ver.wp_flag = 'N' AND ver.baselined_flag = 'N' )))
437: OR (p_slice_type = 'SEC' ))

Line 498: , PA_PROJ_ELEM_VER_STRUCTURE pevs

494: , ver.time_phased_type_code
495: FROM
496: PJI_FM_EXTR_PLNVER4 ver
497: , PA_PROJECTS_ALL ppa
498: , PA_PROJ_ELEM_VER_STRUCTURE pevs
499: , PJI_FM_EXTR_PLAN_LINES bl
500: WHERE 1=1
501: AND ver.wp_flag = 'Y'
502: AND bl.project_id = ver.project_id

Line 1122: , PA_PROJ_ELEM_VER_STRUCTURE pevs

1118: PJI_FM_EXTR_PLNVER4 ver
1119: , PA_RESOURCE_ASSIGNMENTS ra
1120: , PA_BUDGET_LINES bl
1121: , PA_PROJECTS_ALL ppa
1122: , PA_PROJ_ELEM_VER_STRUCTURE pevs
1123: WHERE
1124: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
1125: AND ra.project_id = ver.PROJECT_ID
1126: AND ra.budget_version_id = ver.plan_version_id

Line 1565: , PA_PROJ_ELEM_VER_STRUCTURE pevs

1561: FROM
1562: PJI_FM_EXTR_PLNVER4 ver
1563: , PJI_FM_EXTR_PLAN_LINES bl
1564: , PA_PROJECTS_ALL ppa
1565: , PA_PROJ_ELEM_VER_STRUCTURE pevs
1566: WHERE 1=1
1567: AND ver.wp_flag = 'Y'
1568: AND bl.project_id = ver.project_id
1569: AND bl.plan_version_id = ver.plan_version_id

Line 4356: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

4352: -1 = prg_delta.SIGN (+) and
4353: prg_delta.SUP_PROJECT_ID is null
4354: ) prg,
4355: PJI_PJP_WBS_HEADER wbs_hdr,
4356: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
4357: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
4358: PA_PROJ_WORKPLAN_ATTR sup_wpa
4359: where
4360: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 4357: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

4353: prg_delta.SUP_PROJECT_ID is null
4354: ) prg,
4355: PJI_PJP_WBS_HEADER wbs_hdr,
4356: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
4357: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
4358: PA_PROJ_WORKPLAN_ATTR sup_wpa
4359: where
4360: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
4361: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 4447: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

4443: -4, pjp.PLAN_TYPE_ID,
4444: wbs_hdr.PLAN_TYPE_ID)),
4445: pjp.PLAN_TYPE_CODE
4446: ) pjp1_i,
4447: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
4448: PA_PROJ_WORKPLAN_ATTR sup_wpa
4449: where
4450: pjp1_i.INSERT_FLAG = 'Y' and
4451: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 5671: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

5667: -1 = prg_delta.SIGN (+) and
5668: prg_delta.SUP_PROJECT_ID is null
5669: ) prg,
5670: PJI_PJP_WBS_HEADER wbs_hdr,
5671: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
5672: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
5673: PA_PROJ_WORKPLAN_ATTR sup_wpa
5674: where
5675: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 5672: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

5668: prg_delta.SUP_PROJECT_ID is null
5669: ) prg,
5670: PJI_PJP_WBS_HEADER wbs_hdr,
5671: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
5672: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
5673: PA_PROJ_WORKPLAN_ATTR sup_wpa
5674: where
5675: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
5676: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 5762: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

5758: -4, pjp.PLAN_TYPE_ID,
5759: wbs_hdr.PLAN_TYPE_ID)),
5760: pjp.PLAN_TYPE_CODE
5761: ) pjp1_i,
5762: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
5763: PA_PROJ_WORKPLAN_ATTR sup_wpa
5764: where
5765: pjp1_i.INSERT_FLAG = 'Y' and
5766: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 6986: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

6982: -1 = prg_delta.SIGN (+) and
6983: prg_delta.SUP_PROJECT_ID is null
6984: ) prg,
6985: PJI_PJP_WBS_HEADER wbs_hdr,
6986: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
6987: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
6988: PA_PROJ_WORKPLAN_ATTR sup_wpa
6989: where
6990: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 6987: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

6983: prg_delta.SUP_PROJECT_ID is null
6984: ) prg,
6985: PJI_PJP_WBS_HEADER wbs_hdr,
6986: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
6987: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
6988: PA_PROJ_WORKPLAN_ATTR sup_wpa
6989: where
6990: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
6991: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 7077: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

7073: -4, pjp.PLAN_TYPE_ID,
7074: wbs_hdr.PLAN_TYPE_ID)),
7075: pjp.PLAN_TYPE_CODE
7076: ) pjp1_i,
7077: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
7078: PA_PROJ_WORKPLAN_ATTR sup_wpa
7079: where
7080: pjp1_i.INSERT_FLAG = 'Y' and
7081: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 8300: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

8296: -1 = prg_delta.SIGN (+) and
8297: prg_delta.SUP_PROJECT_ID is null
8298: ) prg,
8299: PJI_PJP_WBS_HEADER wbs_hdr,
8300: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8301: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8302: PA_PROJ_WORKPLAN_ATTR sup_wpa
8303: where
8304: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 8301: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

8297: prg_delta.SUP_PROJECT_ID is null
8298: ) prg,
8299: PJI_PJP_WBS_HEADER wbs_hdr,
8300: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8301: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8302: PA_PROJ_WORKPLAN_ATTR sup_wpa
8303: where
8304: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
8305: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 8391: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

8387: -4, pjp.PLAN_TYPE_ID,
8388: wbs_hdr.PLAN_TYPE_ID)),
8389: pjp.PLAN_TYPE_CODE
8390: ) pjp1_i,
8391: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
8392: PA_PROJ_WORKPLAN_ATTR sup_wpa
8393: where
8394: pjp1_i.INSERT_FLAG = 'Y' and
8395: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 9614: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

9610: -1 = prg_delta.SIGN (+) and
9611: prg_delta.SUP_PROJECT_ID is null
9612: ) prg,
9613: PJI_PJP_WBS_HEADER wbs_hdr,
9614: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
9615: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
9616: PA_PROJ_WORKPLAN_ATTR sup_wpa
9617: where
9618: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 9615: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

9611: prg_delta.SUP_PROJECT_ID is null
9612: ) prg,
9613: PJI_PJP_WBS_HEADER wbs_hdr,
9614: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
9615: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
9616: PA_PROJ_WORKPLAN_ATTR sup_wpa
9617: where
9618: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
9619: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 9705: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

9701: -4, pjp.PLAN_TYPE_ID,
9702: wbs_hdr.PLAN_TYPE_ID)),
9703: pjp.PLAN_TYPE_CODE
9704: ) pjp1_i,
9705: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
9706: PA_PROJ_WORKPLAN_ATTR sup_wpa
9707: where
9708: pjp1_i.INSERT_FLAG = 'Y' and
9709: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 10928: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

10924: -1 = prg_delta.SIGN (+) and
10925: prg_delta.SUP_PROJECT_ID is null
10926: ) prg,
10927: PJI_PJP_WBS_HEADER wbs_hdr,
10928: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10929: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10930: PA_PROJ_WORKPLAN_ATTR sup_wpa
10931: where
10932: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 10929: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

10925: prg_delta.SUP_PROJECT_ID is null
10926: ) prg,
10927: PJI_PJP_WBS_HEADER wbs_hdr,
10928: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10929: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10930: PA_PROJ_WORKPLAN_ATTR sup_wpa
10931: where
10932: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
10933: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 11019: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

11015: -4, pjp.PLAN_TYPE_ID,
11016: wbs_hdr.PLAN_TYPE_ID)),
11017: pjp.PLAN_TYPE_CODE
11018: ) pjp1_i,
11019: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
11020: PA_PROJ_WORKPLAN_ATTR sup_wpa
11021: where
11022: pjp1_i.INSERT_FLAG = 'Y' and
11023: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 12242: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

12238: -1 = prg_delta.SIGN (+) and
12239: prg_delta.SUP_PROJECT_ID is null
12240: ) prg,
12241: PJI_PJP_WBS_HEADER wbs_hdr,
12242: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12243: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12244: PA_PROJ_WORKPLAN_ATTR sup_wpa
12245: where
12246: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 12243: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

12239: prg_delta.SUP_PROJECT_ID is null
12240: ) prg,
12241: PJI_PJP_WBS_HEADER wbs_hdr,
12242: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12243: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12244: PA_PROJ_WORKPLAN_ATTR sup_wpa
12245: where
12246: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
12247: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 12333: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

12329: -4, pjp.PLAN_TYPE_ID,
12330: wbs_hdr.PLAN_TYPE_ID)),
12331: pjp.PLAN_TYPE_CODE
12332: ) pjp1_i,
12333: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
12334: PA_PROJ_WORKPLAN_ATTR sup_wpa
12335: where
12336: pjp1_i.INSERT_FLAG = 'Y' and
12337: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 13556: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

13552: -1 = prg_delta.SIGN (+) and
13553: prg_delta.SUP_PROJECT_ID is null
13554: ) prg,
13555: PJI_PJP_WBS_HEADER wbs_hdr,
13556: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
13557: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
13558: PA_PROJ_WORKPLAN_ATTR sup_wpa
13559: where
13560: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 13557: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

13553: prg_delta.SUP_PROJECT_ID is null
13554: ) prg,
13555: PJI_PJP_WBS_HEADER wbs_hdr,
13556: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
13557: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
13558: PA_PROJ_WORKPLAN_ATTR sup_wpa
13559: where
13560: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
13561: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 13647: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

13643: -4, pjp.PLAN_TYPE_ID,
13644: wbs_hdr.PLAN_TYPE_ID)),
13645: pjp.PLAN_TYPE_CODE
13646: ) pjp1_i,
13647: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
13648: PA_PROJ_WORKPLAN_ATTR sup_wpa
13649: where
13650: pjp1_i.INSERT_FLAG = 'Y' and
13651: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 14870: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

14866: -1 = prg_delta.SIGN (+) and
14867: prg_delta.SUP_PROJECT_ID is null
14868: ) prg,
14869: PJI_PJP_WBS_HEADER wbs_hdr,
14870: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14871: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14872: PA_PROJ_WORKPLAN_ATTR sup_wpa
14873: where
14874: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 14871: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

14867: prg_delta.SUP_PROJECT_ID is null
14868: ) prg,
14869: PJI_PJP_WBS_HEADER wbs_hdr,
14870: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14871: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14872: PA_PROJ_WORKPLAN_ATTR sup_wpa
14873: where
14874: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
14875: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 14961: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

14957: -4, pjp.PLAN_TYPE_ID,
14958: wbs_hdr.PLAN_TYPE_ID)),
14959: pjp.PLAN_TYPE_CODE
14960: ) pjp1_i,
14961: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
14962: PA_PROJ_WORKPLAN_ATTR sup_wpa
14963: where
14964: pjp1_i.INSERT_FLAG = 'Y' and
14965: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 16184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

16180: -1 = prg_delta.SIGN (+) and
16181: prg_delta.SUP_PROJECT_ID is null
16182: ) prg,
16183: PJI_PJP_WBS_HEADER wbs_hdr,
16184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16186: PA_PROJ_WORKPLAN_ATTR sup_wpa
16187: where
16188: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 16185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

16181: prg_delta.SUP_PROJECT_ID is null
16182: ) prg,
16183: PJI_PJP_WBS_HEADER wbs_hdr,
16184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16186: PA_PROJ_WORKPLAN_ATTR sup_wpa
16187: where
16188: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
16189: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 16275: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

16271: -4, pjp.PLAN_TYPE_ID,
16272: wbs_hdr.PLAN_TYPE_ID)),
16273: pjp.PLAN_TYPE_CODE
16274: ) pjp1_i,
16275: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
16276: PA_PROJ_WORKPLAN_ATTR sup_wpa
16277: where
16278: pjp1_i.INSERT_FLAG = 'Y' and
16279: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and