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_WORKPLAN_ATTR

Line 6769: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

6765: OUTLINE(@"SEL$1")
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")

Line 6777: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 8063: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 8153: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 8263: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

8259: OUTLINE(@"SEL$1")
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")

Line 8271: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 9557: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 9647: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 9757: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

9753: OUTLINE(@"SEL$1")
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")

Line 9765: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 11051: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 11141: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 11250: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

11246: OUTLINE(@"SEL$1")
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")

Line 11258: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 12544: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 12634: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 12744: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

12740: OUTLINE(@"SEL$1")
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")

Line 12752: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 14038: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 14128: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 14237: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

14233: OUTLINE(@"SEL$1")
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")

Line 14245: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 15531: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 15621: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 15730: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

15726: OUTLINE(@"SEL$1")
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")

Line 15738: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 17024: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 17114: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 17224: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

17220: OUTLINE(@"SEL$1")
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")

Line 17232: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 18518: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 18608: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 18718: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

18714: OUTLINE(@"SEL$1")
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")

Line 18726: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 20012: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 20102: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 20212: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

20208: OUTLINE(@"SEL$1")
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")

Line 20220: INDEX_RS_ASC(@"SEL$2" "SUP_WPA"@"SEL$2" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))

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"))
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")

Line 21506: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 21596: PA_PROJ_WORKPLAN_ATTR sup_wpa

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