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 PJI_AC_AGGR_PJP1

Line 618: ,p_tabname => 'PJI_AC_AGGR_PJP1'

614: ,p_partname => 'P'||g_worker_id
615: ,p_percent => 10);
616:
617: GATHER_TEMP_STATS(p_ownname => l_pji_schema
618: ,p_tabname => 'PJI_AC_AGGR_PJP1'
619: ,p_partname => 'P'||g_worker_id
620: ,p_percent => 10);
621:
622:

Line 6535: from PJI_AC_AGGR_PJP1 pjp1

6531: -- where pjp1.WORKER_ID = p_worker_id and
6532: -- nvl(pjp1.LINE_TYPE, 'X') <> 'AGGR_PLAN';
6533:
6534: delete /*+ PARALLEL(pjp1) */
6535: from PJI_AC_AGGR_PJP1 pjp1
6536: where pjp1.WORKER_ID = p_worker_id and
6537: nvl(pjp1.RECORD_TYPE, 'X') <> 'A';
6538:
6539: end if;

Line 21879: insert /+ parallel(PJI_AC_AGGR_PJP1) /

21875: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
21876: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
21877: nvl(sum(pjp1.CUSTOM15), 0) = 0);
21878:
21879: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
21880: into PJI_AC_AGGR_PJP1 partition(P1)
21881: (
21882: WORKER_ID,
21883: RECORD_TYPE,

Line 21880: into PJI_AC_AGGR_PJP1 partition(P1)

21876: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
21877: nvl(sum(pjp1.CUSTOM15), 0) = 0);
21878:
21879: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
21880: into PJI_AC_AGGR_PJP1 partition(P1)
21881: (
21882: WORKER_ID,
21883: RECORD_TYPE,
21884: PRG_LEVEL,

Line 21997: PJI_AC_AGGR_PJP1 pjp1

21993: sum(pjp1.CUSTOM13) CUSTOM13,
21994: sum(pjp1.CUSTOM14) CUSTOM14,
21995: sum(pjp1.CUSTOM15) CUSTOM15
21996: from
21997: PJI_AC_AGGR_PJP1 pjp1
21998: where
21999: pjp1.WORKER_ID = p_worker_id
22000: group by
22001: pjp1.WORKER_ID,

Line 22297: insert /+ parallel(PJI_AC_AGGR_PJP1) /

22293: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
22294: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
22295: nvl(sum(pjp1.CUSTOM15), 0) = 0);
22296:
22297: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22298: into PJI_AC_AGGR_PJP1 partition(P2)
22299: (
22300: WORKER_ID,
22301: RECORD_TYPE,

Line 22298: into PJI_AC_AGGR_PJP1 partition(P2)

22294: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
22295: nvl(sum(pjp1.CUSTOM15), 0) = 0);
22296:
22297: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22298: into PJI_AC_AGGR_PJP1 partition(P2)
22299: (
22300: WORKER_ID,
22301: RECORD_TYPE,
22302: PRG_LEVEL,

Line 22415: PJI_AC_AGGR_PJP1 pjp1

22411: sum(pjp1.CUSTOM13) CUSTOM13,
22412: sum(pjp1.CUSTOM14) CUSTOM14,
22413: sum(pjp1.CUSTOM15) CUSTOM15
22414: from
22415: PJI_AC_AGGR_PJP1 pjp1
22416: where
22417: pjp1.WORKER_ID = p_worker_id
22418: group by
22419: pjp1.WORKER_ID,

Line 22714: insert /+ parallel(PJI_AC_AGGR_PJP1) /

22710: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
22711: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
22712: nvl(sum(pjp1.CUSTOM15), 0) = 0);
22713:
22714: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22715: into PJI_AC_AGGR_PJP1 partition(P3)
22716: (
22717: WORKER_ID,
22718: RECORD_TYPE,

Line 22715: into PJI_AC_AGGR_PJP1 partition(P3)

22711: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
22712: nvl(sum(pjp1.CUSTOM15), 0) = 0);
22713:
22714: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
22715: into PJI_AC_AGGR_PJP1 partition(P3)
22716: (
22717: WORKER_ID,
22718: RECORD_TYPE,
22719: PRG_LEVEL,

Line 22832: PJI_AC_AGGR_PJP1 pjp1

22828: sum(pjp1.CUSTOM13) CUSTOM13,
22829: sum(pjp1.CUSTOM14) CUSTOM14,
22830: sum(pjp1.CUSTOM15) CUSTOM15
22831: from
22832: PJI_AC_AGGR_PJP1 pjp1
22833: where
22834: pjp1.WORKER_ID = p_worker_id
22835: group by
22836: pjp1.WORKER_ID,

Line 23131: insert /+ parallel(PJI_AC_AGGR_PJP1) /

23127: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
23128: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
23129: nvl(sum(pjp1.CUSTOM15), 0) = 0);
23130:
23131: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23132: into PJI_AC_AGGR_PJP1 partition(P4)
23133: (
23134: WORKER_ID,
23135: RECORD_TYPE,

Line 23132: into PJI_AC_AGGR_PJP1 partition(P4)

23128: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
23129: nvl(sum(pjp1.CUSTOM15), 0) = 0);
23130:
23131: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23132: into PJI_AC_AGGR_PJP1 partition(P4)
23133: (
23134: WORKER_ID,
23135: RECORD_TYPE,
23136: PRG_LEVEL,

Line 23249: PJI_AC_AGGR_PJP1 pjp1

23245: sum(pjp1.CUSTOM13) CUSTOM13,
23246: sum(pjp1.CUSTOM14) CUSTOM14,
23247: sum(pjp1.CUSTOM15) CUSTOM15
23248: from
23249: PJI_AC_AGGR_PJP1 pjp1
23250: where
23251: pjp1.WORKER_ID = p_worker_id
23252: group by
23253: pjp1.WORKER_ID,

Line 23548: insert /+ parallel(PJI_AC_AGGR_PJP1) /

23544: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
23545: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
23546: nvl(sum(pjp1.CUSTOM15), 0) = 0);
23547:
23548: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23549: into PJI_AC_AGGR_PJP1 partition(P5)
23550: (
23551: WORKER_ID,
23552: RECORD_TYPE,

Line 23549: into PJI_AC_AGGR_PJP1 partition(P5)

23545: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
23546: nvl(sum(pjp1.CUSTOM15), 0) = 0);
23547:
23548: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23549: into PJI_AC_AGGR_PJP1 partition(P5)
23550: (
23551: WORKER_ID,
23552: RECORD_TYPE,
23553: PRG_LEVEL,

Line 23666: PJI_AC_AGGR_PJP1 pjp1

23662: sum(pjp1.CUSTOM13) CUSTOM13,
23663: sum(pjp1.CUSTOM14) CUSTOM14,
23664: sum(pjp1.CUSTOM15) CUSTOM15
23665: from
23666: PJI_AC_AGGR_PJP1 pjp1
23667: where
23668: pjp1.WORKER_ID = p_worker_id
23669: group by
23670: pjp1.WORKER_ID,

Line 23965: insert /+ parallel(PJI_AC_AGGR_PJP1) /

23961: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
23962: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
23963: nvl(sum(pjp1.CUSTOM15), 0) = 0);
23964:
23965: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23966: into PJI_AC_AGGR_PJP1 partition(P6)
23967: (
23968: WORKER_ID,
23969: RECORD_TYPE,

Line 23966: into PJI_AC_AGGR_PJP1 partition(P6)

23962: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
23963: nvl(sum(pjp1.CUSTOM15), 0) = 0);
23964:
23965: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
23966: into PJI_AC_AGGR_PJP1 partition(P6)
23967: (
23968: WORKER_ID,
23969: RECORD_TYPE,
23970: PRG_LEVEL,

Line 24083: PJI_AC_AGGR_PJP1 pjp1

24079: sum(pjp1.CUSTOM13) CUSTOM13,
24080: sum(pjp1.CUSTOM14) CUSTOM14,
24081: sum(pjp1.CUSTOM15) CUSTOM15
24082: from
24083: PJI_AC_AGGR_PJP1 pjp1
24084: where
24085: pjp1.WORKER_ID = p_worker_id
24086: group by
24087: pjp1.WORKER_ID,

Line 24382: insert /+ parallel(PJI_AC_AGGR_PJP1) /

24378: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
24379: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
24380: nvl(sum(pjp1.CUSTOM15), 0) = 0);
24381:
24382: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24383: into PJI_AC_AGGR_PJP1 partition(P7)
24384: (
24385: WORKER_ID,
24386: RECORD_TYPE,

Line 24383: into PJI_AC_AGGR_PJP1 partition(P7)

24379: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
24380: nvl(sum(pjp1.CUSTOM15), 0) = 0);
24381:
24382: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24383: into PJI_AC_AGGR_PJP1 partition(P7)
24384: (
24385: WORKER_ID,
24386: RECORD_TYPE,
24387: PRG_LEVEL,

Line 24500: PJI_AC_AGGR_PJP1 pjp1

24496: sum(pjp1.CUSTOM13) CUSTOM13,
24497: sum(pjp1.CUSTOM14) CUSTOM14,
24498: sum(pjp1.CUSTOM15) CUSTOM15
24499: from
24500: PJI_AC_AGGR_PJP1 pjp1
24501: where
24502: pjp1.WORKER_ID = p_worker_id
24503: group by
24504: pjp1.WORKER_ID,

Line 24799: insert /+ parallel(PJI_AC_AGGR_PJP1) /

24795: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
24796: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
24797: nvl(sum(pjp1.CUSTOM15), 0) = 0);
24798:
24799: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24800: into PJI_AC_AGGR_PJP1 partition(P8)
24801: (
24802: WORKER_ID,
24803: RECORD_TYPE,

Line 24800: into PJI_AC_AGGR_PJP1 partition(P8)

24796: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
24797: nvl(sum(pjp1.CUSTOM15), 0) = 0);
24798:
24799: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
24800: into PJI_AC_AGGR_PJP1 partition(P8)
24801: (
24802: WORKER_ID,
24803: RECORD_TYPE,
24804: PRG_LEVEL,

Line 24917: PJI_AC_AGGR_PJP1 pjp1

24913: sum(pjp1.CUSTOM13) CUSTOM13,
24914: sum(pjp1.CUSTOM14) CUSTOM14,
24915: sum(pjp1.CUSTOM15) CUSTOM15
24916: from
24917: PJI_AC_AGGR_PJP1 pjp1
24918: where
24919: pjp1.WORKER_ID = p_worker_id
24920: group by
24921: pjp1.WORKER_ID,

Line 25216: insert /+ parallel(PJI_AC_AGGR_PJP1) /

25212: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
25213: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
25214: nvl(sum(pjp1.CUSTOM15), 0) = 0);
25215:
25216: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
25217: into PJI_AC_AGGR_PJP1 partition(P9)
25218: (
25219: WORKER_ID,
25220: RECORD_TYPE,

Line 25217: into PJI_AC_AGGR_PJP1 partition(P9)

25213: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
25214: nvl(sum(pjp1.CUSTOM15), 0) = 0);
25215:
25216: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
25217: into PJI_AC_AGGR_PJP1 partition(P9)
25218: (
25219: WORKER_ID,
25220: RECORD_TYPE,
25221: PRG_LEVEL,

Line 25334: PJI_AC_AGGR_PJP1 pjp1

25330: sum(pjp1.CUSTOM13) CUSTOM13,
25331: sum(pjp1.CUSTOM14) CUSTOM14,
25332: sum(pjp1.CUSTOM15) CUSTOM15
25333: from
25334: PJI_AC_AGGR_PJP1 pjp1
25335: where
25336: pjp1.WORKER_ID = p_worker_id
25337: group by
25338: pjp1.WORKER_ID,

Line 25633: insert /+ parallel(PJI_AC_AGGR_PJP1) /

25629: nvl(sum(pjp1.CUSTOM13), 0) = 0 and
25630: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
25631: nvl(sum(pjp1.CUSTOM15), 0) = 0);
25632:
25633: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
25634: into PJI_AC_AGGR_PJP1 partition(P10)
25635: (
25636: WORKER_ID,
25637: RECORD_TYPE,

Line 25634: into PJI_AC_AGGR_PJP1 partition(P10)

25630: nvl(sum(pjp1.CUSTOM14), 0) = 0 and
25631: nvl(sum(pjp1.CUSTOM15), 0) = 0);
25632:
25633: insert /*+ parallel(PJI_AC_AGGR_PJP1) */
25634: into PJI_AC_AGGR_PJP1 partition(P10)
25635: (
25636: WORKER_ID,
25637: RECORD_TYPE,
25638: PRG_LEVEL,

Line 25751: PJI_AC_AGGR_PJP1 pjp1

25747: sum(pjp1.CUSTOM13) CUSTOM13,
25748: sum(pjp1.CUSTOM14) CUSTOM14,
25749: sum(pjp1.CUSTOM15) CUSTOM15
25750: from
25751: PJI_AC_AGGR_PJP1 pjp1
25752: where
25753: pjp1.WORKER_ID = p_worker_id
25754: group by
25755: pjp1.WORKER_ID,