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_RM_SUM_MAIN dependencies on DUAL

Line 7: -- Data extraction consists of several steps that are coded as individual

3:
4: -- The main procedure is procedure SUMMARIZE, it is invoked from a concurrent
5: -- program.
6: --
7: -- Data extraction consists of several steps that are coded as individual
8: -- program units. Procedure RUN_PROCESS invokes processing steps in the
9: -- appropriate order. Before we call RUN_PROCESS we initialize the process,
10: -- this is done in INIT_PROCESS. After process completes successfully we
11: -- reset process status in WRAPUP_PROCESS. These are three main program

Line 211: dual;

207: sysdate START_DATE,
208: null END_DATE,
209: null COMPLETION_TEXT
210: from
211: dual;
212:
213: end if;
214:
215: end RUN_SETUP;

Line 433: dual;

429: sysdate START_DATE,
430: null END_DATE,
431: null COMPLETION_TEXT
432: from
433: dual;
434:
435: -- ------------------------------------------------------------------------
436: -- Initialize Resource Management portion of stage 2 PJI summarization.
437: -- ------------------------------------------------------------------------

Line 1072: select 'G1' INVERT_ID from dual union all

1068: from
1069: PJI_FM_EXTR_PLN_LOG log,
1070: PJI_ORG_EXTR_INFO info,
1071: (
1072: select 'G1' INVERT_ID from dual union all
1073: select 'G2' INVERT_ID from dual
1074: ) invert
1075: where
1076: bitand(to_number(log.RECORD_TYPE_CODE), 15) > 0 and

Line 1073: select 'G2' INVERT_ID from dual

1069: PJI_FM_EXTR_PLN_LOG log,
1070: PJI_ORG_EXTR_INFO info,
1071: (
1072: select 'G1' INVERT_ID from dual union all
1073: select 'G2' INVERT_ID from dual
1074: ) invert
1075: where
1076: bitand(to_number(log.RECORD_TYPE_CODE), 15) > 0 and
1077: log.PROJECT_ORG_ID = info.ORG_ID;

Line 1115: select 'EN' INVERT_ID from dual union all

1111: 'PA', info.PA_CALENDAR_MAX_DATE) CALENDAR_MAX_DATE
1112: from
1113: PJI_ORG_EXTR_INFO info,
1114: (
1115: select 'EN' INVERT_ID from dual union all
1116: select 'GL' INVERT_ID from dual union all
1117: select 'PA' INVERT_ID from dual
1118: ) invert
1119: where

Line 1116: select 'GL' INVERT_ID from dual union all

1112: from
1113: PJI_ORG_EXTR_INFO info,
1114: (
1115: select 'EN' INVERT_ID from dual union all
1116: select 'GL' INVERT_ID from dual union all
1117: select 'PA' INVERT_ID from dual
1118: ) invert
1119: where
1120: info.ORG_ID <> -1

Line 1117: select 'PA' INVERT_ID from dual

1113: PJI_ORG_EXTR_INFO info,
1114: (
1115: select 'EN' INVERT_ID from dual union all
1116: select 'GL' INVERT_ID from dual union all
1117: select 'PA' INVERT_ID from dual
1118: ) invert
1119: where
1120: info.ORG_ID <> -1
1121: ) info