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 1073: select 'G1' INVERT_ID from dual union all

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

Line 1074: select 'G2' INVERT_ID from dual

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

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

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

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

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

Line 1118: select 'PA' INVERT_ID from dual

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