[Home] [Help]
20903:
20904: if (p_worker_id =1) then
20905: -- Query for Partition 1
20906:
20907: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
20908: into PJI_AC_AGGR_PJP1 partition(P1)
20909: (
20910: WORKER_ID,
20911: RECORD_TYPE,
20904: if (p_worker_id =1) then
20905: -- Query for Partition 1
20906:
20907: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
20908: into PJI_AC_AGGR_PJP1 partition(P1)
20909: (
20910: WORKER_ID,
20911: RECORD_TYPE,
20912: PRG_LEVEL,
21166: pjp1.CUSTOM13,
21167: pjp1.CUSTOM14,
21168: pjp1.CUSTOM15
21169: from
21170: PJI_AC_AGGR_PJP1 pjp1,
21171: PJI_PJP_WBS_HEADER wbs_hdr,
21172: PA_XBS_DENORM wbs,
21173: PJI_XBS_DENORM prg,
21174: (
21262: pjp1.CUSTOM13,
21263: pjp1.CUSTOM14,
21264: pjp1.CUSTOM15
21265: from
21266: PJI_AC_AGGR_PJP1 pjp1,
21267: PJI_PJP_WBS_HEADER wbs_hdr,
21268: PJI_XBS_DENORM prg
21269: where
21270: prg.STRUCT_TYPE = 'PRG' and
21485: sup_wpa.PROJ_ELEMENT_ID is not null)));
21486: elsif (p_worker_id =2) then
21487: -- Query for Partition 2
21488:
21489: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
21490: into PJI_AC_AGGR_PJP1 partition(P2)
21491: (
21492: WORKER_ID,
21493: RECORD_TYPE,
21486: elsif (p_worker_id =2) then
21487: -- Query for Partition 2
21488:
21489: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
21490: into PJI_AC_AGGR_PJP1 partition(P2)
21491: (
21492: WORKER_ID,
21493: RECORD_TYPE,
21494: PRG_LEVEL,
21748: pjp1.CUSTOM13,
21749: pjp1.CUSTOM14,
21750: pjp1.CUSTOM15
21751: from
21752: PJI_AC_AGGR_PJP1 pjp1,
21753: PJI_PJP_WBS_HEADER wbs_hdr,
21754: PA_XBS_DENORM wbs,
21755: PJI_XBS_DENORM prg,
21756: (
21844: pjp1.CUSTOM13,
21845: pjp1.CUSTOM14,
21846: pjp1.CUSTOM15
21847: from
21848: PJI_AC_AGGR_PJP1 pjp1,
21849: PJI_PJP_WBS_HEADER wbs_hdr,
21850: PJI_XBS_DENORM prg
21851: where
21852: prg.STRUCT_TYPE = 'PRG' and
22067: sup_wpa.PROJ_ELEMENT_ID is not null)));
22068: elsif (p_worker_id =3) then
22069: -- Query for Partition 3
22070:
22071: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22072: into PJI_AC_AGGR_PJP1 partition(P3)
22073: (
22074: WORKER_ID,
22075: RECORD_TYPE,
22068: elsif (p_worker_id =3) then
22069: -- Query for Partition 3
22070:
22071: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22072: into PJI_AC_AGGR_PJP1 partition(P3)
22073: (
22074: WORKER_ID,
22075: RECORD_TYPE,
22076: PRG_LEVEL,
22330: pjp1.CUSTOM13,
22331: pjp1.CUSTOM14,
22332: pjp1.CUSTOM15
22333: from
22334: PJI_AC_AGGR_PJP1 pjp1,
22335: PJI_PJP_WBS_HEADER wbs_hdr,
22336: PA_XBS_DENORM wbs,
22337: PJI_XBS_DENORM prg,
22338: (
22426: pjp1.CUSTOM13,
22427: pjp1.CUSTOM14,
22428: pjp1.CUSTOM15
22429: from
22430: PJI_AC_AGGR_PJP1 pjp1,
22431: PJI_PJP_WBS_HEADER wbs_hdr,
22432: PJI_XBS_DENORM prg
22433: where
22434: prg.STRUCT_TYPE = 'PRG' and
22649: sup_wpa.PROJ_ELEMENT_ID is not null)));
22650: elsif (p_worker_id =4) then
22651: -- Query for Partition 4
22652:
22653: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22654: into PJI_AC_AGGR_PJP1 partition(P4)
22655: (
22656: WORKER_ID,
22657: RECORD_TYPE,
22650: elsif (p_worker_id =4) then
22651: -- Query for Partition 4
22652:
22653: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22654: into PJI_AC_AGGR_PJP1 partition(P4)
22655: (
22656: WORKER_ID,
22657: RECORD_TYPE,
22658: PRG_LEVEL,
22912: pjp1.CUSTOM13,
22913: pjp1.CUSTOM14,
22914: pjp1.CUSTOM15
22915: from
22916: PJI_AC_AGGR_PJP1 pjp1,
22917: PJI_PJP_WBS_HEADER wbs_hdr,
22918: PA_XBS_DENORM wbs,
22919: PJI_XBS_DENORM prg,
22920: (
23008: pjp1.CUSTOM13,
23009: pjp1.CUSTOM14,
23010: pjp1.CUSTOM15
23011: from
23012: PJI_AC_AGGR_PJP1 pjp1,
23013: PJI_PJP_WBS_HEADER wbs_hdr,
23014: PJI_XBS_DENORM prg
23015: where
23016: prg.STRUCT_TYPE = 'PRG' and
23231: sup_wpa.PROJ_ELEMENT_ID is not null)));
23232: elsif (p_worker_id =5) then
23233: -- Query for Partition 5
23234:
23235: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23236: into PJI_AC_AGGR_PJP1 partition(P5)
23237: (
23238: WORKER_ID,
23239: RECORD_TYPE,
23232: elsif (p_worker_id =5) then
23233: -- Query for Partition 5
23234:
23235: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23236: into PJI_AC_AGGR_PJP1 partition(P5)
23237: (
23238: WORKER_ID,
23239: RECORD_TYPE,
23240: PRG_LEVEL,
23494: pjp1.CUSTOM13,
23495: pjp1.CUSTOM14,
23496: pjp1.CUSTOM15
23497: from
23498: PJI_AC_AGGR_PJP1 pjp1,
23499: PJI_PJP_WBS_HEADER wbs_hdr,
23500: PA_XBS_DENORM wbs,
23501: PJI_XBS_DENORM prg,
23502: (
23590: pjp1.CUSTOM13,
23591: pjp1.CUSTOM14,
23592: pjp1.CUSTOM15
23593: from
23594: PJI_AC_AGGR_PJP1 pjp1,
23595: PJI_PJP_WBS_HEADER wbs_hdr,
23596: PJI_XBS_DENORM prg
23597: where
23598: prg.STRUCT_TYPE = 'PRG' and
23813: sup_wpa.PROJ_ELEMENT_ID is not null)));
23814: elsif (p_worker_id =6) then
23815: -- Query for Partition 6
23816:
23817: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23818: into PJI_AC_AGGR_PJP1 partition(P6)
23819: (
23820: WORKER_ID,
23821: RECORD_TYPE,
23814: elsif (p_worker_id =6) then
23815: -- Query for Partition 6
23816:
23817: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23818: into PJI_AC_AGGR_PJP1 partition(P6)
23819: (
23820: WORKER_ID,
23821: RECORD_TYPE,
23822: PRG_LEVEL,
24076: pjp1.CUSTOM13,
24077: pjp1.CUSTOM14,
24078: pjp1.CUSTOM15
24079: from
24080: PJI_AC_AGGR_PJP1 pjp1,
24081: PJI_PJP_WBS_HEADER wbs_hdr,
24082: PA_XBS_DENORM wbs,
24083: PJI_XBS_DENORM prg,
24084: (
24172: pjp1.CUSTOM13,
24173: pjp1.CUSTOM14,
24174: pjp1.CUSTOM15
24175: from
24176: PJI_AC_AGGR_PJP1 pjp1,
24177: PJI_PJP_WBS_HEADER wbs_hdr,
24178: PJI_XBS_DENORM prg
24179: where
24180: prg.STRUCT_TYPE = 'PRG' and
24395: sup_wpa.PROJ_ELEMENT_ID is not null)));
24396: elsif (p_worker_id =7) then
24397: -- Query for Partition 7
24398:
24399: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24400: into PJI_AC_AGGR_PJP1 partition(P7)
24401: (
24402: WORKER_ID,
24403: RECORD_TYPE,
24396: elsif (p_worker_id =7) then
24397: -- Query for Partition 7
24398:
24399: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24400: into PJI_AC_AGGR_PJP1 partition(P7)
24401: (
24402: WORKER_ID,
24403: RECORD_TYPE,
24404: PRG_LEVEL,
24658: pjp1.CUSTOM13,
24659: pjp1.CUSTOM14,
24660: pjp1.CUSTOM15
24661: from
24662: PJI_AC_AGGR_PJP1 pjp1,
24663: PJI_PJP_WBS_HEADER wbs_hdr,
24664: PA_XBS_DENORM wbs,
24665: PJI_XBS_DENORM prg,
24666: (
24754: pjp1.CUSTOM13,
24755: pjp1.CUSTOM14,
24756: pjp1.CUSTOM15
24757: from
24758: PJI_AC_AGGR_PJP1 pjp1,
24759: PJI_PJP_WBS_HEADER wbs_hdr,
24760: PJI_XBS_DENORM prg
24761: where
24762: prg.STRUCT_TYPE = 'PRG' and
24977: sup_wpa.PROJ_ELEMENT_ID is not null)));
24978: elsif (p_worker_id =8) then
24979: -- Query for Partition 8
24980:
24981: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24982: into PJI_AC_AGGR_PJP1 partition(P8)
24983: (
24984: WORKER_ID,
24985: RECORD_TYPE,
24978: elsif (p_worker_id =8) then
24979: -- Query for Partition 8
24980:
24981: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24982: into PJI_AC_AGGR_PJP1 partition(P8)
24983: (
24984: WORKER_ID,
24985: RECORD_TYPE,
24986: PRG_LEVEL,
25240: pjp1.CUSTOM13,
25241: pjp1.CUSTOM14,
25242: pjp1.CUSTOM15
25243: from
25244: PJI_AC_AGGR_PJP1 pjp1,
25245: PJI_PJP_WBS_HEADER wbs_hdr,
25246: PA_XBS_DENORM wbs,
25247: PJI_XBS_DENORM prg,
25248: (
25336: pjp1.CUSTOM13,
25337: pjp1.CUSTOM14,
25338: pjp1.CUSTOM15
25339: from
25340: PJI_AC_AGGR_PJP1 pjp1,
25341: PJI_PJP_WBS_HEADER wbs_hdr,
25342: PJI_XBS_DENORM prg
25343: where
25344: prg.STRUCT_TYPE = 'PRG' and
25559: sup_wpa.PROJ_ELEMENT_ID is not null)));
25560: elsif (p_worker_id =9) then
25561: -- Query for Partition 9
25562:
25563: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
25564: into PJI_AC_AGGR_PJP1 partition(P9)
25565: (
25566: WORKER_ID,
25567: RECORD_TYPE,
25560: elsif (p_worker_id =9) then
25561: -- Query for Partition 9
25562:
25563: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
25564: into PJI_AC_AGGR_PJP1 partition(P9)
25565: (
25566: WORKER_ID,
25567: RECORD_TYPE,
25568: PRG_LEVEL,
25822: pjp1.CUSTOM13,
25823: pjp1.CUSTOM14,
25824: pjp1.CUSTOM15
25825: from
25826: PJI_AC_AGGR_PJP1 pjp1,
25827: PJI_PJP_WBS_HEADER wbs_hdr,
25828: PA_XBS_DENORM wbs,
25829: PJI_XBS_DENORM prg,
25830: (
25918: pjp1.CUSTOM13,
25919: pjp1.CUSTOM14,
25920: pjp1.CUSTOM15
25921: from
25922: PJI_AC_AGGR_PJP1 pjp1,
25923: PJI_PJP_WBS_HEADER wbs_hdr,
25924: PJI_XBS_DENORM prg
25925: where
25926: prg.STRUCT_TYPE = 'PRG' and
26141: sup_wpa.PROJ_ELEMENT_ID is not null)));
26142: elsif (p_worker_id =10) then
26143: -- Query for Partition 10
26144:
26145: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
26146: into PJI_AC_AGGR_PJP1 partition(P10)
26147: (
26148: WORKER_ID,
26149: RECORD_TYPE,
26142: elsif (p_worker_id =10) then
26143: -- Query for Partition 10
26144:
26145: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
26146: into PJI_AC_AGGR_PJP1 partition(P10)
26147: (
26148: WORKER_ID,
26149: RECORD_TYPE,
26150: PRG_LEVEL,
26404: pjp1.CUSTOM13,
26405: pjp1.CUSTOM14,
26406: pjp1.CUSTOM15
26407: from
26408: PJI_AC_AGGR_PJP1 pjp1,
26409: PJI_PJP_WBS_HEADER wbs_hdr,
26410: PA_XBS_DENORM wbs,
26411: PJI_XBS_DENORM prg,
26412: (
26500: pjp1.CUSTOM13,
26501: pjp1.CUSTOM14,
26502: pjp1.CUSTOM15
26503: from
26504: PJI_AC_AGGR_PJP1 pjp1,
26505: PJI_PJP_WBS_HEADER wbs_hdr,
26506: PJI_XBS_DENORM prg
26507: where
26508: prg.STRUCT_TYPE = 'PRG' and
37217:
37218: if (p_worker_id =1) then
37219: -- Query for Partition 1
37220:
37221: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
37222: into PJI_AC_AGGR_PJP1 partition(P1)
37223: (
37224: WORKER_ID,
37225: RECORD_TYPE,
37218: if (p_worker_id =1) then
37219: -- Query for Partition 1
37220:
37221: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
37222: into PJI_AC_AGGR_PJP1 partition(P1)
37223: (
37224: WORKER_ID,
37225: RECORD_TYPE,
37226: PRG_LEVEL,
37475: pjp1.CUSTOM13,
37476: pjp1.CUSTOM14,
37477: pjp1.CUSTOM15
37478: from
37479: PJI_AC_AGGR_PJP1 pjp1,
37480: PJI_PJP_WBS_HEADER wbs_hdr,
37481: PA_PROJ_ELEMENTS prj_emt,
37482: PA_XBS_DENORM prg,
37483: PJI_XBS_DENORM_DELTA prg_delta
37560:
37561: elsif (p_worker_id =2) then
37562: -- Query for Partition 2
37563:
37564: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
37565: into PJI_AC_AGGR_PJP1 partition(P2)
37566: (
37567: WORKER_ID,
37568: RECORD_TYPE,
37561: elsif (p_worker_id =2) then
37562: -- Query for Partition 2
37563:
37564: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
37565: into PJI_AC_AGGR_PJP1 partition(P2)
37566: (
37567: WORKER_ID,
37568: RECORD_TYPE,
37569: PRG_LEVEL,
37818: pjp1.CUSTOM13,
37819: pjp1.CUSTOM14,
37820: pjp1.CUSTOM15
37821: from
37822: PJI_AC_AGGR_PJP1 pjp1,
37823: PJI_PJP_WBS_HEADER wbs_hdr,
37824: PA_PROJ_ELEMENTS prj_emt,
37825: PA_XBS_DENORM prg,
37826: PJI_XBS_DENORM_DELTA prg_delta
37902: pjp.CURRENCY_CODE;
37903: elsif (p_worker_id =3) then
37904: -- Query for Partition 3
37905:
37906: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
37907: into PJI_AC_AGGR_PJP1 partition(P3)
37908: (
37909: WORKER_ID,
37910: RECORD_TYPE,
37903: elsif (p_worker_id =3) then
37904: -- Query for Partition 3
37905:
37906: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
37907: into PJI_AC_AGGR_PJP1 partition(P3)
37908: (
37909: WORKER_ID,
37910: RECORD_TYPE,
37911: PRG_LEVEL,
38160: pjp1.CUSTOM13,
38161: pjp1.CUSTOM14,
38162: pjp1.CUSTOM15
38163: from
38164: PJI_AC_AGGR_PJP1 pjp1,
38165: PJI_PJP_WBS_HEADER wbs_hdr,
38166: PA_PROJ_ELEMENTS prj_emt,
38167: PA_XBS_DENORM prg,
38168: PJI_XBS_DENORM_DELTA prg_delta
38244: pjp.CURRENCY_CODE;
38245: elsif (p_worker_id =4) then
38246: -- Query for Partition 4
38247:
38248: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
38249: into PJI_AC_AGGR_PJP1 partition(P4)
38250: (
38251: WORKER_ID,
38252: RECORD_TYPE,
38245: elsif (p_worker_id =4) then
38246: -- Query for Partition 4
38247:
38248: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
38249: into PJI_AC_AGGR_PJP1 partition(P4)
38250: (
38251: WORKER_ID,
38252: RECORD_TYPE,
38253: PRG_LEVEL,
38502: pjp1.CUSTOM13,
38503: pjp1.CUSTOM14,
38504: pjp1.CUSTOM15
38505: from
38506: PJI_AC_AGGR_PJP1 pjp1,
38507: PJI_PJP_WBS_HEADER wbs_hdr,
38508: PA_PROJ_ELEMENTS prj_emt,
38509: PA_XBS_DENORM prg,
38510: PJI_XBS_DENORM_DELTA prg_delta
38586: pjp.CURRENCY_CODE;
38587: elsif (p_worker_id =5) then
38588: -- Query for Partition 5
38589:
38590: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
38591: into PJI_AC_AGGR_PJP1 partition(P5)
38592: (
38593: WORKER_ID,
38594: RECORD_TYPE,
38587: elsif (p_worker_id =5) then
38588: -- Query for Partition 5
38589:
38590: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
38591: into PJI_AC_AGGR_PJP1 partition(P5)
38592: (
38593: WORKER_ID,
38594: RECORD_TYPE,
38595: PRG_LEVEL,
38844: pjp1.CUSTOM13,
38845: pjp1.CUSTOM14,
38846: pjp1.CUSTOM15
38847: from
38848: PJI_AC_AGGR_PJP1 pjp1,
38849: PJI_PJP_WBS_HEADER wbs_hdr,
38850: PA_PROJ_ELEMENTS prj_emt,
38851: PA_XBS_DENORM prg,
38852: PJI_XBS_DENORM_DELTA prg_delta
38928: pjp.CURRENCY_CODE;
38929: elsif (p_worker_id =6) then
38930: -- Query for Partition 6
38931:
38932: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
38933: into PJI_AC_AGGR_PJP1 partition(P6)
38934: (
38935: WORKER_ID,
38936: RECORD_TYPE,
38929: elsif (p_worker_id =6) then
38930: -- Query for Partition 6
38931:
38932: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
38933: into PJI_AC_AGGR_PJP1 partition(P6)
38934: (
38935: WORKER_ID,
38936: RECORD_TYPE,
38937: PRG_LEVEL,
39186: pjp1.CUSTOM13,
39187: pjp1.CUSTOM14,
39188: pjp1.CUSTOM15
39189: from
39190: PJI_AC_AGGR_PJP1 pjp1,
39191: PJI_PJP_WBS_HEADER wbs_hdr,
39192: PA_PROJ_ELEMENTS prj_emt,
39193: PA_XBS_DENORM prg,
39194: PJI_XBS_DENORM_DELTA prg_delta
39270: pjp.CURRENCY_CODE;
39271: elsif (p_worker_id =7) then
39272: -- Query for Partition 7
39273:
39274: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
39275: into PJI_AC_AGGR_PJP1 partition(P7)
39276: (
39277: WORKER_ID,
39278: RECORD_TYPE,
39271: elsif (p_worker_id =7) then
39272: -- Query for Partition 7
39273:
39274: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
39275: into PJI_AC_AGGR_PJP1 partition(P7)
39276: (
39277: WORKER_ID,
39278: RECORD_TYPE,
39279: PRG_LEVEL,
39528: pjp1.CUSTOM13,
39529: pjp1.CUSTOM14,
39530: pjp1.CUSTOM15
39531: from
39532: PJI_AC_AGGR_PJP1 pjp1,
39533: PJI_PJP_WBS_HEADER wbs_hdr,
39534: PA_PROJ_ELEMENTS prj_emt,
39535: PA_XBS_DENORM prg,
39536: PJI_XBS_DENORM_DELTA prg_delta
39612: pjp.CURRENCY_CODE;
39613: elsif (p_worker_id =8) then
39614: -- Query for Partition 8
39615:
39616: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
39617: into PJI_AC_AGGR_PJP1 partition(P8)
39618: (
39619: WORKER_ID,
39620: RECORD_TYPE,
39613: elsif (p_worker_id =8) then
39614: -- Query for Partition 8
39615:
39616: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
39617: into PJI_AC_AGGR_PJP1 partition(P8)
39618: (
39619: WORKER_ID,
39620: RECORD_TYPE,
39621: PRG_LEVEL,
39870: pjp1.CUSTOM13,
39871: pjp1.CUSTOM14,
39872: pjp1.CUSTOM15
39873: from
39874: PJI_AC_AGGR_PJP1 pjp1,
39875: PJI_PJP_WBS_HEADER wbs_hdr,
39876: PA_PROJ_ELEMENTS prj_emt,
39877: PA_XBS_DENORM prg,
39878: PJI_XBS_DENORM_DELTA prg_delta
39954: pjp.CURRENCY_CODE;
39955: elsif (p_worker_id =9) then
39956: -- Query for Partition 9
39957:
39958: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
39959: into PJI_AC_AGGR_PJP1 partition(P9)
39960: (
39961: WORKER_ID,
39962: RECORD_TYPE,
39955: elsif (p_worker_id =9) then
39956: -- Query for Partition 9
39957:
39958: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
39959: into PJI_AC_AGGR_PJP1 partition(P9)
39960: (
39961: WORKER_ID,
39962: RECORD_TYPE,
39963: PRG_LEVEL,
40212: pjp1.CUSTOM13,
40213: pjp1.CUSTOM14,
40214: pjp1.CUSTOM15
40215: from
40216: PJI_AC_AGGR_PJP1 pjp1,
40217: PJI_PJP_WBS_HEADER wbs_hdr,
40218: PA_PROJ_ELEMENTS prj_emt,
40219: PA_XBS_DENORM prg,
40220: PJI_XBS_DENORM_DELTA prg_delta
40296: pjp.CURRENCY_CODE;
40297: elsif (p_worker_id =10) then
40298: -- Query for Partition 10
40299:
40300: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
40301: into PJI_AC_AGGR_PJP1 partition(P10)
40302: (
40303: WORKER_ID,
40304: RECORD_TYPE,
40297: elsif (p_worker_id =10) then
40298: -- Query for Partition 10
40299:
40300: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
40301: into PJI_AC_AGGR_PJP1 partition(P10)
40302: (
40303: WORKER_ID,
40304: RECORD_TYPE,
40305: PRG_LEVEL,
40554: pjp1.CUSTOM13,
40555: pjp1.CUSTOM14,
40556: pjp1.CUSTOM15
40557: from
40558: PJI_AC_AGGR_PJP1 pjp1,
40559: PJI_PJP_WBS_HEADER wbs_hdr,
40560: PA_PROJ_ELEMENTS prj_emt,
40561: PA_XBS_DENORM prg,
40562: PJI_XBS_DENORM_DELTA prg_delta
40903: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
40904: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
40905: nvl(sum(pjp1.CUSTOM15), 0) = 0);
40906:
40907: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
40908: into PJI_AC_AGGR_PJP1 partition(P1)
40909: (
40910: WORKER_ID,
40911: RECORD_TYPE,
40904: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
40905: nvl(sum(pjp1.CUSTOM15), 0) = 0);
40906:
40907: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
40908: into PJI_AC_AGGR_PJP1 partition(P1)
40909: (
40910: WORKER_ID,
40911: RECORD_TYPE,
40912: PRG_LEVEL,
41021: sum(pjp1.CUSTOM13) CUSTOM13,
41022: sum(pjp1.CUSTOM14) CUSTOM14,
41023: sum(pjp1.CUSTOM15) CUSTOM15
41024: from
41025: PJI_AC_AGGR_PJP1 pjp1
41026: where
41027: pjp1.WORKER_ID = p_worker_id
41028: group by
41029: pjp1.WORKER_ID,
41321: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
41322: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
41323: nvl(sum(pjp1.CUSTOM15), 0) = 0);
41324:
41325: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
41326: into PJI_AC_AGGR_PJP1 partition(P2)
41327: (
41328: WORKER_ID,
41329: RECORD_TYPE,
41322: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
41323: nvl(sum(pjp1.CUSTOM15), 0) = 0);
41324:
41325: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
41326: into PJI_AC_AGGR_PJP1 partition(P2)
41327: (
41328: WORKER_ID,
41329: RECORD_TYPE,
41330: PRG_LEVEL,
41439: sum(pjp1.CUSTOM13) CUSTOM13,
41440: sum(pjp1.CUSTOM14) CUSTOM14,
41441: sum(pjp1.CUSTOM15) CUSTOM15
41442: from
41443: PJI_AC_AGGR_PJP1 pjp1
41444: where
41445: pjp1.WORKER_ID = p_worker_id
41446: group by
41447: pjp1.WORKER_ID,
41738: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
41739: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
41740: nvl(sum(pjp1.CUSTOM15), 0) = 0);
41741:
41742: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
41743: into PJI_AC_AGGR_PJP1 partition(P3)
41744: (
41745: WORKER_ID,
41746: RECORD_TYPE,
41739: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
41740: nvl(sum(pjp1.CUSTOM15), 0) = 0);
41741:
41742: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
41743: into PJI_AC_AGGR_PJP1 partition(P3)
41744: (
41745: WORKER_ID,
41746: RECORD_TYPE,
41747: PRG_LEVEL,
41856: sum(pjp1.CUSTOM13) CUSTOM13,
41857: sum(pjp1.CUSTOM14) CUSTOM14,
41858: sum(pjp1.CUSTOM15) CUSTOM15
41859: from
41860: PJI_AC_AGGR_PJP1 pjp1
41861: where
41862: pjp1.WORKER_ID = p_worker_id
41863: group by
41864: pjp1.WORKER_ID,
42155: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
42156: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
42157: nvl(sum(pjp1.CUSTOM15), 0) = 0);
42158:
42159: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
42160: into PJI_AC_AGGR_PJP1 partition(P4)
42161: (
42162: WORKER_ID,
42163: RECORD_TYPE,
42156: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
42157: nvl(sum(pjp1.CUSTOM15), 0) = 0);
42158:
42159: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
42160: into PJI_AC_AGGR_PJP1 partition(P4)
42161: (
42162: WORKER_ID,
42163: RECORD_TYPE,
42164: PRG_LEVEL,
42273: sum(pjp1.CUSTOM13) CUSTOM13,
42274: sum(pjp1.CUSTOM14) CUSTOM14,
42275: sum(pjp1.CUSTOM15) CUSTOM15
42276: from
42277: PJI_AC_AGGR_PJP1 pjp1
42278: where
42279: pjp1.WORKER_ID = p_worker_id
42280: group by
42281: pjp1.WORKER_ID,
42572: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
42573: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
42574: nvl(sum(pjp1.CUSTOM15), 0) = 0);
42575:
42576: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
42577: into PJI_AC_AGGR_PJP1 partition(P5)
42578: (
42579: WORKER_ID,
42580: RECORD_TYPE,
42573: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
42574: nvl(sum(pjp1.CUSTOM15), 0) = 0);
42575:
42576: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
42577: into PJI_AC_AGGR_PJP1 partition(P5)
42578: (
42579: WORKER_ID,
42580: RECORD_TYPE,
42581: PRG_LEVEL,
42690: sum(pjp1.CUSTOM13) CUSTOM13,
42691: sum(pjp1.CUSTOM14) CUSTOM14,
42692: sum(pjp1.CUSTOM15) CUSTOM15
42693: from
42694: PJI_AC_AGGR_PJP1 pjp1
42695: where
42696: pjp1.WORKER_ID = p_worker_id
42697: group by
42698: pjp1.WORKER_ID,
42989: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
42990: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
42991: nvl(sum(pjp1.CUSTOM15), 0) = 0);
42992:
42993: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
42994: into PJI_AC_AGGR_PJP1 partition(P6)
42995: (
42996: WORKER_ID,
42997: RECORD_TYPE,
42990: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
42991: nvl(sum(pjp1.CUSTOM15), 0) = 0);
42992:
42993: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
42994: into PJI_AC_AGGR_PJP1 partition(P6)
42995: (
42996: WORKER_ID,
42997: RECORD_TYPE,
42998: PRG_LEVEL,
43107: sum(pjp1.CUSTOM13) CUSTOM13,
43108: sum(pjp1.CUSTOM14) CUSTOM14,
43109: sum(pjp1.CUSTOM15) CUSTOM15
43110: from
43111: PJI_AC_AGGR_PJP1 pjp1
43112: where
43113: pjp1.WORKER_ID = p_worker_id
43114: group by
43115: pjp1.WORKER_ID,
43406: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
43407: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
43408: nvl(sum(pjp1.CUSTOM15), 0) = 0);
43409:
43410: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
43411: into PJI_AC_AGGR_PJP1 partition(P7)
43412: (
43413: WORKER_ID,
43414: RECORD_TYPE,
43407: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
43408: nvl(sum(pjp1.CUSTOM15), 0) = 0);
43409:
43410: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
43411: into PJI_AC_AGGR_PJP1 partition(P7)
43412: (
43413: WORKER_ID,
43414: RECORD_TYPE,
43415: PRG_LEVEL,
43524: sum(pjp1.CUSTOM13) CUSTOM13,
43525: sum(pjp1.CUSTOM14) CUSTOM14,
43526: sum(pjp1.CUSTOM15) CUSTOM15
43527: from
43528: PJI_AC_AGGR_PJP1 pjp1
43529: where
43530: pjp1.WORKER_ID = p_worker_id
43531: group by
43532: pjp1.WORKER_ID,
43823: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
43824: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
43825: nvl(sum(pjp1.CUSTOM15), 0) = 0);
43826:
43827: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
43828: into PJI_AC_AGGR_PJP1 partition(P8)
43829: (
43830: WORKER_ID,
43831: RECORD_TYPE,
43824: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
43825: nvl(sum(pjp1.CUSTOM15), 0) = 0);
43826:
43827: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
43828: into PJI_AC_AGGR_PJP1 partition(P8)
43829: (
43830: WORKER_ID,
43831: RECORD_TYPE,
43832: PRG_LEVEL,
43941: sum(pjp1.CUSTOM13) CUSTOM13,
43942: sum(pjp1.CUSTOM14) CUSTOM14,
43943: sum(pjp1.CUSTOM15) CUSTOM15
43944: from
43945: PJI_AC_AGGR_PJP1 pjp1
43946: where
43947: pjp1.WORKER_ID = p_worker_id
43948: group by
43949: pjp1.WORKER_ID,
44240: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
44241: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
44242: nvl(sum(pjp1.CUSTOM15), 0) = 0);
44243:
44244: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
44245: into PJI_AC_AGGR_PJP1 partition(P9)
44246: (
44247: WORKER_ID,
44248: RECORD_TYPE,
44241: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
44242: nvl(sum(pjp1.CUSTOM15), 0) = 0);
44243:
44244: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
44245: into PJI_AC_AGGR_PJP1 partition(P9)
44246: (
44247: WORKER_ID,
44248: RECORD_TYPE,
44249: PRG_LEVEL,
44358: sum(pjp1.CUSTOM13) CUSTOM13,
44359: sum(pjp1.CUSTOM14) CUSTOM14,
44360: sum(pjp1.CUSTOM15) CUSTOM15
44361: from
44362: PJI_AC_AGGR_PJP1 pjp1
44363: where
44364: pjp1.WORKER_ID = p_worker_id
44365: group by
44366: pjp1.WORKER_ID,
44657: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
44658: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
44659: nvl(sum(pjp1.CUSTOM15), 0) = 0);
44660:
44661: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
44662: into PJI_AC_AGGR_PJP1 partition(P10)
44663: (
44664: WORKER_ID,
44665: RECORD_TYPE,
44658: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
44659: nvl(sum(pjp1.CUSTOM15), 0) = 0);
44660:
44661: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
44662: into PJI_AC_AGGR_PJP1 partition(P10)
44663: (
44664: WORKER_ID,
44665: RECORD_TYPE,
44666: PRG_LEVEL,
44775: sum(pjp1.CUSTOM13) CUSTOM13,
44776: sum(pjp1.CUSTOM14) CUSTOM14,
44777: sum(pjp1.CUSTOM15) CUSTOM15
44778: from
44779: PJI_AC_AGGR_PJP1 pjp1
44780: where
44781: pjp1.WORKER_ID = p_worker_id
44782: group by
44783: pjp1.WORKER_ID,