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_FM_SUM_EXTR dependencies on PJI_ORG_EXTR_INFO

Line 53: tabname => 'PJI_ORG_EXTR_INFO',

49: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);');
50:
51: -- implicit commit
52: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
53: tabname => 'PJI_ORG_EXTR_INFO',
54: percent => 10,
55: degree => PJI_UTILS.
56: GET_DEGREE_OF_PARALLELISM);
57: -- implicit commit

Line 59: indname => 'PJI_ORG_EXTR_INFO_N1',

55: degree => PJI_UTILS.
56: GET_DEGREE_OF_PARALLELISM);
57: -- implicit commit
58: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
59: indname => 'PJI_ORG_EXTR_INFO_N1',
60: percent => 10);
61:
62: commit;
63:

Line 152: PJI_ORG_EXTR_INFO prj_info,

148: 'PRVDR_PA', res_info.PF_CURRENCY_CODE,
149: 'RECVR_PA', prj_info.PF_CURRENCY_CODE,
150: 'EXP', res_info.PF_CURRENCY_CODE) PF_CURRENCY_CODE
151: from -- bug 3092751: Changes in table order
152: PJI_ORG_EXTR_INFO prj_info,
153: (
154: select /*+ full(tmp1) parallel(tmp1) */
155: distinct
156: PROJECT_ID,

Line 169: PJI_ORG_EXTR_INFO res_info,

165: PJI_FM_AGGR_FIN1 tmp1
166: where
167: WORKER_ID = p_worker_id
168: ) tmp1,
169: PJI_ORG_EXTR_INFO res_info,
170: (
171: select 'PRVDR_GL' INVERT_ID from dual union all
172: select 'RECVR_GL' INVERT_ID from dual union all
173: select 'PRVDR_PA' INVERT_ID from dual union all

Line 201: PJI_ORG_EXTR_INFO prj_info,

197: 'PRVDR_PA', res_info.PF_CURRENCY_CODE,
198: 'RECVR_PA', prj_info.PF_CURRENCY_CODE,
199: 'EXP', res_info.PF_CURRENCY_CODE) PF_CURRENCY_CODE
200: from -- bug 3092751: changes in table order
201: PJI_ORG_EXTR_INFO prj_info,
202: PJI_FM_PROJ_BATCH_MAP map,
203: (
204: select /*+ full(tmp2) parallel(tmp2) */
205: distinct

Line 219: PJI_ORG_EXTR_INFO res_info,

215: where
216: WORKER_ID = 0 and
217: RECORD_TYPE = 'A'
218: ) tmp2,
219: PJI_ORG_EXTR_INFO res_info,
220: (
221: select 'PRVDR_GL' INVERT_ID from dual union all
222: select 'RECVR_GL' INVERT_ID from dual union all
223: select 'PRVDR_PA' INVERT_ID from dual union all

Line 243: PJI_ORG_EXTR_INFO prj_info,

239: 'GL', tmp1.GL_TIME_ID,
240: 'PA', tmp1.PA_TIME_ID) TIME_ID,
241: prj_info.PF_CURRENCY_CODE
242: from -- bug 3092751: changes in table order
243: PJI_ORG_EXTR_INFO prj_info,
244: (
245: select /*+ parallel(tmp1) full(tmp1) */
246: distinct
247: PROJECT_ID,

Line 274: PJI_ORG_EXTR_INFO prj_info,

270: 'GL', tmp2.GL_TIME_ID,
271: 'PA', tmp2.PA_TIME_ID) TIME_ID,
272: prj_info.PF_CURRENCY_CODE
273: from -- bug 3092751: changes in table order
274: PJI_ORG_EXTR_INFO prj_info,
275: PJI_FM_PROJ_BATCH_MAP map,
276: (
277: select /*+ parallel(tmp2) full(tmp2) */
278: distinct

Line 307: PJI_ORG_EXTR_INFO prj_info,

303: 'GL', tmp2.GL_TIME_ID,
304: 'PA', tmp2.PA_TIME_ID) TIME_ID,
305: prj_info.PF_CURRENCY_CODE
306: from
307: PJI_ORG_EXTR_INFO prj_info,
308: PJI_FM_PROJ_BATCH_MAP map,
309: /* commented and changed as below for bug 6894858
310: (
311: select /*+ parallel(cmt) full(cmt)

Line 1787: PJI_ORG_EXTR_INFO prj_info,

1783: tmp2.CBS_ELEMENT_ID /*Added for CBS Changes */
1784: from
1785: PJI_FM_DNGL_FIN tmp2,
1786: PJI_FM_PROJ_BATCH_MAP map,
1787: PJI_ORG_EXTR_INFO prj_info,
1788: PJI_ORG_EXTR_INFO res_info,
1789: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
1790: PJI_FM_AGGR_DLY_RATES prj_pa_rt
1791: where

Line 1788: PJI_ORG_EXTR_INFO res_info,

1784: from
1785: PJI_FM_DNGL_FIN tmp2,
1786: PJI_FM_PROJ_BATCH_MAP map,
1787: PJI_ORG_EXTR_INFO prj_info,
1788: PJI_ORG_EXTR_INFO res_info,
1789: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
1790: PJI_FM_AGGR_DLY_RATES prj_pa_rt
1791: where
1792: tmp2.WORKER_ID = 0 and

Line 3162: PJI_ORG_EXTR_INFO prj_info,

3158: tmp2.AR_COUNT_OVERDUE
3159: from
3160: PJI_FM_DNGL_ACT tmp2,
3161: PJI_FM_PROJ_BATCH_MAP map,
3162: PJI_ORG_EXTR_INFO prj_info,
3163: PJI_FM_AGGR_DLY_RATES gl_rt,
3164: PJI_FM_AGGR_DLY_RATES pa_rt
3165: where
3166: tmp2.WORKER_ID = 0 and

Line 4159: PJI_ORG_EXTR_INFO prj_info,

4155: tmp1.TOTAL_HRS_A,
4156: tmp1.BILL_HRS_A,
4157: tmp1.CBS_ELEMENT_ID /* Added for CBS Changes */
4158: from -- bug 3092751: Changes in table order
4159: PJI_ORG_EXTR_INFO prj_info,
4160: (
4161: select /*+ parallel(tmp1) */
4162: decode(l_params_cost_flag,
4163: 'N', 'N',

Line 4327: PJI_ORG_EXTR_INFO res_info,

4323: 'J')),
4324: tmp1.TXN_CURRENCY_CODE,
4325: tmp1.CBS_ELEMENT_ID /* Added for CBS Changes */
4326: ) tmp1,
4327: PJI_ORG_EXTR_INFO res_info,
4328: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
4329: PJI_FM_AGGR_DLY_RATES prj_pa_rt
4330: where
4331: tmp1.EXPENDITURE_ORGANIZATION_ID is not null and

Line 5632: PJI_ORG_EXTR_INFO prj_info,

5628: sum(tmp1.AR_COUNT_DUE) AR_COUNT_DUE,
5629: sum(tmp1.AR_COUNT_OVERDUE) AR_COUNT_OVERDUE
5630: from
5631: PJI_FM_AGGR_ACT1 tmp1,
5632: PJI_ORG_EXTR_INFO prj_info,
5633: PJI_FM_AGGR_DLY_RATES gl_rt,
5634: PJI_FM_AGGR_DLY_RATES pa_rt
5635: where
5636: tmp1.WORKER_ID = p_worker_id and