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

Line 3785: , PA_PROJ_ELEM_VER_STRUCTURE pevs

3781: , pa_projects_all ppa
3782: , PJI_ORG_EXTR_INFO oei
3783: , pji_time_cal_period_v prd
3784: , PJI_FM_AGGR_DLY_RATES rates
3785: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3786: WHERE 1=1
3787: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3788: AND ra.project_id = ver.PROJECT_ID
3789: AND ra.budget_version_id = ver.plan_version_id

Line 4074: , PA_PROJ_ELEM_VER_STRUCTURE pevs

4070: , pa_resource_asSIGNments ra
4071: , PA_BUDGET_LINES bl
4072: , pa_projects_all ppa
4073: , PJI_FM_AGGR_DLY_RATES rates
4074: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4075: WHERE 1=1
4076: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
4077: AND ra.project_id = ver.PROJECT_ID
4078: AND ra.budget_version_id = ver.plan_version_id

Line 5689: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where

5685: fpo.FIN_PLAN_TYPE_ID <> l_workplan_type_id and -- Bug# 5208322
5686: 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'
5687: )
5688: 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
5689: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where
5690: bv.FIN_PLAN_TYPE_ID = l_workplan_type_id and -- Bug# 5208322
5691: bv.PROJECT_STRUCTURE_VERSION_ID = ppevs.ELEMENT_VERSION_ID and
5692: (
5693: decode(BITAND(l_refresh_code,g_all_plans),g_all_plans,'N',

Line 6770: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

6766: OUTLINE(@"INS$1")
6767: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
6768: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
6769: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
6770: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
6771: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
6772: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
6773: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
6774: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 6775: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

6771: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
6772: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
6773: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
6774: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
6775: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
6776: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
6777: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
6778: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
6779: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 6779: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

6775: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
6776: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
6777: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
6778: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
6779: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
6780: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
6781: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
6782: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
6783: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 8061: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

8057: -1 = prg_delta.SIGN (+) and
8058: prg_delta.SUP_PROJECT_ID is null
8059: ) prg,
8060: PJI_PJP_WBS_HEADER wbs_hdr,
8061: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8062: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8063: PA_PROJ_WORKPLAN_ATTR sup_wpa
8064: where
8065: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 8062: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

8058: prg_delta.SUP_PROJECT_ID is null
8059: ) prg,
8060: PJI_PJP_WBS_HEADER wbs_hdr,
8061: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8062: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8063: PA_PROJ_WORKPLAN_ATTR sup_wpa
8064: where
8065: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
8066: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 8152: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

8148: -4, pjp.PLAN_TYPE_ID,
8149: wbs_hdr.PLAN_TYPE_ID)),
8150: pjp.PLAN_TYPE_CODE
8151: ) pjp1_i,
8152: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
8153: PA_PROJ_WORKPLAN_ATTR sup_wpa
8154: where
8155: pjp1_i.INSERT_FLAG = 'Y' and
8156: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 8264: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

8260: OUTLINE(@"INS$1")
8261: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
8262: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
8263: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
8264: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
8265: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
8266: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
8267: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
8268: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 8269: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

8265: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
8266: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
8267: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
8268: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
8269: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
8270: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
8271: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
8272: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
8273: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 8273: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

8269: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
8270: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
8271: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
8272: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
8273: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
8274: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
8275: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
8276: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
8277: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 9555: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

9551: -1 = prg_delta.SIGN (+) and
9552: prg_delta.SUP_PROJECT_ID is null
9553: ) prg,
9554: PJI_PJP_WBS_HEADER wbs_hdr,
9555: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
9556: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
9557: PA_PROJ_WORKPLAN_ATTR sup_wpa
9558: where
9559: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 9556: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

9552: prg_delta.SUP_PROJECT_ID is null
9553: ) prg,
9554: PJI_PJP_WBS_HEADER wbs_hdr,
9555: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
9556: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
9557: PA_PROJ_WORKPLAN_ATTR sup_wpa
9558: where
9559: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
9560: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 9646: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

9642: -4, pjp.PLAN_TYPE_ID,
9643: wbs_hdr.PLAN_TYPE_ID)),
9644: pjp.PLAN_TYPE_CODE
9645: ) pjp1_i,
9646: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
9647: PA_PROJ_WORKPLAN_ATTR sup_wpa
9648: where
9649: pjp1_i.INSERT_FLAG = 'Y' and
9650: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 9758: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

9754: OUTLINE(@"INS$1")
9755: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
9756: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
9757: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
9758: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
9759: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
9760: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
9761: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
9762: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 9763: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

9759: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
9760: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
9761: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
9762: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
9763: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
9764: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
9765: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
9766: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
9767: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 9767: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

9763: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
9764: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
9765: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
9766: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
9767: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
9768: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
9769: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
9770: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
9771: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 11049: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

11045: -1 = prg_delta.SIGN (+) and
11046: prg_delta.SUP_PROJECT_ID is null
11047: ) prg,
11048: PJI_PJP_WBS_HEADER wbs_hdr,
11049: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
11050: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
11051: PA_PROJ_WORKPLAN_ATTR sup_wpa
11052: where
11053: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 11050: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

11046: prg_delta.SUP_PROJECT_ID is null
11047: ) prg,
11048: PJI_PJP_WBS_HEADER wbs_hdr,
11049: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
11050: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
11051: PA_PROJ_WORKPLAN_ATTR sup_wpa
11052: where
11053: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
11054: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 11140: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

11136: -4, pjp.PLAN_TYPE_ID,
11137: wbs_hdr.PLAN_TYPE_ID)),
11138: pjp.PLAN_TYPE_CODE
11139: ) pjp1_i,
11140: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
11141: PA_PROJ_WORKPLAN_ATTR sup_wpa
11142: where
11143: pjp1_i.INSERT_FLAG = 'Y' and
11144: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 11251: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

11247: OUTLINE(@"INS$1")
11248: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
11249: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
11250: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
11251: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
11252: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
11253: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
11254: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
11255: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 11256: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

11252: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
11253: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
11254: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
11255: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
11256: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
11257: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
11258: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
11259: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
11260: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 11260: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

11256: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
11257: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
11258: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
11259: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
11260: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
11261: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
11262: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
11263: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
11264: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 12542: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

12538: -1 = prg_delta.SIGN (+) and
12539: prg_delta.SUP_PROJECT_ID is null
12540: ) prg,
12541: PJI_PJP_WBS_HEADER wbs_hdr,
12542: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12543: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12544: PA_PROJ_WORKPLAN_ATTR sup_wpa
12545: where
12546: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 12543: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

12539: prg_delta.SUP_PROJECT_ID is null
12540: ) prg,
12541: PJI_PJP_WBS_HEADER wbs_hdr,
12542: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12543: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12544: PA_PROJ_WORKPLAN_ATTR sup_wpa
12545: where
12546: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
12547: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 12633: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

12629: -4, pjp.PLAN_TYPE_ID,
12630: wbs_hdr.PLAN_TYPE_ID)),
12631: pjp.PLAN_TYPE_CODE
12632: ) pjp1_i,
12633: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
12634: PA_PROJ_WORKPLAN_ATTR sup_wpa
12635: where
12636: pjp1_i.INSERT_FLAG = 'Y' and
12637: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 12745: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

12741: OUTLINE(@"INS$1")
12742: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
12743: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
12744: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
12745: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
12746: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
12747: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
12748: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
12749: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 12750: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

12746: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
12747: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
12748: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
12749: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
12750: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
12751: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
12752: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
12753: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
12754: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 12754: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

12750: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
12751: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
12752: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
12753: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
12754: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
12755: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
12756: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
12757: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
12758: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 14036: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

14032: -1 = prg_delta.SIGN (+) and
14033: prg_delta.SUP_PROJECT_ID is null
14034: ) prg,
14035: PJI_PJP_WBS_HEADER wbs_hdr,
14036: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14037: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14038: PA_PROJ_WORKPLAN_ATTR sup_wpa
14039: where
14040: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 14037: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

14033: prg_delta.SUP_PROJECT_ID is null
14034: ) prg,
14035: PJI_PJP_WBS_HEADER wbs_hdr,
14036: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14037: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14038: PA_PROJ_WORKPLAN_ATTR sup_wpa
14039: where
14040: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
14041: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 14127: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

14123: -4, pjp.PLAN_TYPE_ID,
14124: wbs_hdr.PLAN_TYPE_ID)),
14125: pjp.PLAN_TYPE_CODE
14126: ) pjp1_i,
14127: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
14128: PA_PROJ_WORKPLAN_ATTR sup_wpa
14129: where
14130: pjp1_i.INSERT_FLAG = 'Y' and
14131: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 14238: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

14234: OUTLINE(@"INS$1")
14235: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
14236: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
14237: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
14238: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
14239: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
14240: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
14241: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
14242: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 14243: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

14239: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
14240: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
14241: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
14242: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
14243: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
14244: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
14245: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
14246: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
14247: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 14247: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

14243: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
14244: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
14245: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
14246: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
14247: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
14248: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
14249: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
14250: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
14251: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 15529: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

15525: -1 = prg_delta.SIGN (+) and
15526: prg_delta.SUP_PROJECT_ID is null
15527: ) prg,
15528: PJI_PJP_WBS_HEADER wbs_hdr,
15529: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
15530: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
15531: PA_PROJ_WORKPLAN_ATTR sup_wpa
15532: where
15533: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 15530: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

15526: prg_delta.SUP_PROJECT_ID is null
15527: ) prg,
15528: PJI_PJP_WBS_HEADER wbs_hdr,
15529: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
15530: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
15531: PA_PROJ_WORKPLAN_ATTR sup_wpa
15532: where
15533: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
15534: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 15620: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

15616: -4, pjp.PLAN_TYPE_ID,
15617: wbs_hdr.PLAN_TYPE_ID)),
15618: pjp.PLAN_TYPE_CODE
15619: ) pjp1_i,
15620: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
15621: PA_PROJ_WORKPLAN_ATTR sup_wpa
15622: where
15623: pjp1_i.INSERT_FLAG = 'Y' and
15624: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 15731: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

15727: OUTLINE(@"INS$1")
15728: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
15729: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
15730: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
15731: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
15732: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
15733: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
15734: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
15735: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 15736: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

15732: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
15733: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
15734: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
15735: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
15736: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
15737: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
15738: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
15739: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
15740: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 15740: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

15736: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
15737: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
15738: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
15739: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
15740: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
15741: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
15742: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
15743: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
15744: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 17022: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

17018: -1 = prg_delta.SIGN (+) and
17019: prg_delta.SUP_PROJECT_ID is null
17020: ) prg,
17021: PJI_PJP_WBS_HEADER wbs_hdr,
17022: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
17023: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
17024: PA_PROJ_WORKPLAN_ATTR sup_wpa
17025: where
17026: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 17023: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

17019: prg_delta.SUP_PROJECT_ID is null
17020: ) prg,
17021: PJI_PJP_WBS_HEADER wbs_hdr,
17022: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
17023: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
17024: PA_PROJ_WORKPLAN_ATTR sup_wpa
17025: where
17026: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
17027: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 17113: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

17109: -4, pjp.PLAN_TYPE_ID,
17110: wbs_hdr.PLAN_TYPE_ID)),
17111: pjp.PLAN_TYPE_CODE
17112: ) pjp1_i,
17113: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
17114: PA_PROJ_WORKPLAN_ATTR sup_wpa
17115: where
17116: pjp1_i.INSERT_FLAG = 'Y' and
17117: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 17225: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

17221: OUTLINE(@"INS$1")
17222: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
17223: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
17224: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
17225: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
17226: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
17227: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
17228: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
17229: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 17230: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

17226: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
17227: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
17228: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
17229: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
17230: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
17231: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
17232: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
17233: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
17234: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 17234: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

17230: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
17231: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
17232: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
17233: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
17234: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
17235: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
17236: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
17237: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
17238: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 18516: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

18512: -1 = prg_delta.SIGN (+) and
18513: prg_delta.SUP_PROJECT_ID is null
18514: ) prg,
18515: PJI_PJP_WBS_HEADER wbs_hdr,
18516: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
18517: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
18518: PA_PROJ_WORKPLAN_ATTR sup_wpa
18519: where
18520: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 18517: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

18513: prg_delta.SUP_PROJECT_ID is null
18514: ) prg,
18515: PJI_PJP_WBS_HEADER wbs_hdr,
18516: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
18517: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
18518: PA_PROJ_WORKPLAN_ATTR sup_wpa
18519: where
18520: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
18521: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 18607: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

18603: -4, pjp.PLAN_TYPE_ID,
18604: wbs_hdr.PLAN_TYPE_ID)),
18605: pjp.PLAN_TYPE_CODE
18606: ) pjp1_i,
18607: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
18608: PA_PROJ_WORKPLAN_ATTR sup_wpa
18609: where
18610: pjp1_i.INSERT_FLAG = 'Y' and
18611: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 18719: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

18715: OUTLINE(@"INS$1")
18716: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
18717: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
18718: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
18719: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
18720: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
18721: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
18722: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
18723: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 18724: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

18720: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
18721: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
18722: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
18723: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
18724: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
18725: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
18726: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
18727: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
18728: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 18728: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

18724: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
18725: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
18726: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
18727: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
18728: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
18729: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
18730: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
18731: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
18732: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 20010: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

20006: -1 = prg_delta.SIGN (+) and
20007: prg_delta.SUP_PROJECT_ID is null
20008: ) prg,
20009: PJI_PJP_WBS_HEADER wbs_hdr,
20010: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
20011: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
20012: PA_PROJ_WORKPLAN_ATTR sup_wpa
20013: where
20014: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 20011: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

20007: prg_delta.SUP_PROJECT_ID is null
20008: ) prg,
20009: PJI_PJP_WBS_HEADER wbs_hdr,
20010: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
20011: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
20012: PA_PROJ_WORKPLAN_ATTR sup_wpa
20013: where
20014: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
20015: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 20101: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

20097: -4, pjp.PLAN_TYPE_ID,
20098: wbs_hdr.PLAN_TYPE_ID)),
20099: pjp.PLAN_TYPE_CODE
20100: ) pjp1_i,
20101: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
20102: PA_PROJ_WORKPLAN_ATTR sup_wpa
20103: where
20104: pjp1_i.INSERT_FLAG = 'Y' and
20105: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 20213: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

20209: OUTLINE(@"INS$1")
20210: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
20211: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
20212: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
20213: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
20214: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
20215: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
20216: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
20217: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")

Line 20218: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

20214: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")
20215: USE_NL(@"SEL$1" "SUP_WPA"@"SEL$1")
20216: USE_NL(@"SEL$1" "SUP_FIN_VER"@"SEL$1")
20217: NO_ACCESS(@"SEL$2" "PJP"@"SEL$2")
20218: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
20219: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
20220: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
20221: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
20222: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

Line 20222: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))

20218: INDEX_RS_ASC(@"SEL$2" "SUB_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
20219: NO_ACCESS(@"SEL$2" "PRG"@"SEL$2")
20220: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
20221: INDEX_RS_ASC(@"SEL$2" "WBS_HDR"@"SEL$2" ("PJI_PJP_WBS_HEADER"."PROJECT_ID" "PJI_PJP_WBS_HEADER"."PLAN_VERSION_ID"))
20222: INDEX_RS_ASC(@"SEL$2" "SUP_VER"@"SEL$2" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
20223: LEADING(@"SEL$2" "PJP"@"SEL$2" "SUB_VER"@"SEL$2" "PRG"@"SEL$2" "SUP_WPA"@"SEL$2" "WBS_HDR"@"SEL$2" "SUP_VER"@"SEL$2")
20224: USE_NL(@"SEL$2" "SUB_VER"@"SEL$2")
20225: USE_HASH(@"SEL$2" "PRG"@"SEL$2")
20226: USE_NL(@"SEL$2" "SUP_WPA"@"SEL$2")

Line 21504: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

21500: -1 = prg_delta.SIGN (+) and
21501: prg_delta.SUP_PROJECT_ID is null
21502: ) prg,
21503: PJI_PJP_WBS_HEADER wbs_hdr,
21504: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
21505: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
21506: PA_PROJ_WORKPLAN_ATTR sup_wpa
21507: where
21508: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 21505: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

21501: prg_delta.SUP_PROJECT_ID is null
21502: ) prg,
21503: PJI_PJP_WBS_HEADER wbs_hdr,
21504: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
21505: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
21506: PA_PROJ_WORKPLAN_ATTR sup_wpa
21507: where
21508: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
21509: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 21595: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

21591: -4, pjp.PLAN_TYPE_ID,
21592: wbs_hdr.PLAN_TYPE_ID)),
21593: pjp.PLAN_TYPE_CODE
21594: ) pjp1_i,
21595: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
21596: PA_PROJ_WORKPLAN_ATTR sup_wpa
21597: where
21598: pjp1_i.INSERT_FLAG = 'Y' and
21599: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and