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_PSI dependencies on PJI_PJP_RMAP_FPR

Line 4159: insert into PJI_PJP_RMAP_FPR psi_i

4155:
4156: if (l_extraction_type = 'INCREMENTAL') then
4157:
4158: -- Actuals
4159: insert into PJI_PJP_RMAP_FPR psi_i
4160: (
4161: WORKER_ID,
4162: STG_ROWID,
4163: TXN_ROWID,

Line 4195: insert into PJI_PJP_RMAP_FPR psi_i

4191: tmp7.TXN_CURRENCY_CODE = psi.TXN_CURRENCY_CODE (+) and
4192: nvl(tmp7.cbs_element_id,-1) = nvl(psi.cbs_element_id(+),-1) ;
4193:
4194: -- coMmitments
4195: insert into PJI_PJP_RMAP_FPR psi_i
4196: (
4197: WORKER_ID,
4198: STG_ROWID,
4199: TXN_ROWID,

Line 4297: (select /+ ordered index(tmp7_r, PJI_PJP_RMAP_FPR_N1) rowid(tmp7) /

4293: BILL_QUANTITY,
4294: LAST_UPDATE_DATE,
4295: LAST_UPDATED_BY,
4296: LAST_UPDATE_LOGIN) =
4297: (select /*+ ordered index(tmp7_r, PJI_PJP_RMAP_FPR_N1) rowid(tmp7) */
4298: decode(nvl(psi.TXN_RAW_COST, 0) + nvl(sum(tmp7.TXN_RAW_COST), 0),
4299: 0, null,
4300: nvl(psi.TXN_RAW_COST, 0) + nvl(sum(tmp7.TXN_RAW_COST), 0)),
4301: decode(nvl(psi.TXN_BILL_RAW_COST, 0) + nvl(sum(tmp7.TXN_BILL_RAW_COST), 0),

Line 4395: PJI_PJP_RMAP_FPR tmp7_r,

4391: l_last_update_date,
4392: l_last_updated_by,
4393: l_last_update_login
4394: from
4395: PJI_PJP_RMAP_FPR tmp7_r,
4396: PJI_FM_AGGR_FIN7 tmp7
4397: where
4398: tmp7_r.WORKER_ID = p_worker_id and
4399: tmp7_r.RECORD_TYPE = 'A' and

Line 4404: (select /+ index(tmp7_r, PJI_PJP_RMAP_FPR_N1) /

4400: tmp7_r.TXN_ROWID is not null and
4401: tmp7.ROWID = tmp7_r.STG_ROWID and
4402: psi.ROWID = tmp7_r.TXN_ROWID)
4403: where psi.ROWID in
4404: (select /*+ index(tmp7_r, PJI_PJP_RMAP_FPR_N1) */
4405: tmp7_r.TXN_ROWID
4406: from
4407: PJI_PJP_RMAP_FPR tmp7_r
4408: where

Line 4407: PJI_PJP_RMAP_FPR tmp7_r

4403: where psi.ROWID in
4404: (select /*+ index(tmp7_r, PJI_PJP_RMAP_FPR_N1) */
4405: tmp7_r.TXN_ROWID
4406: from
4407: PJI_PJP_RMAP_FPR tmp7_r
4408: where
4409: tmp7_r.WORKER_ID = p_worker_id and
4410: tmp7_r.RECORD_TYPE = 'A' and
4411: tmp7_r.TXN_ROWID is not null);

Line 4568: PJI_PJP_RMAP_FPR tmp7_r,

4564: l_created_by CREATED_BY,
4565: l_last_update_login LAST_UPDATE_LOGIN,
4566: cbs_element_id cbs_element_id
4567: from
4568: PJI_PJP_RMAP_FPR tmp7_r,
4569: PJI_FM_AGGR_FIN7 tmp7
4570: where
4571: tmp7_r.WORKER_ID = p_worker_id and
4572: tmp7_r.TXN_ROWID is null and

Line 4631: from PJI_PJP_RMAP_FPR

4627: if (l_extraction_type = 'INCREMENTAL') then
4628:
4629: delete from PJI_FM_AGGR_FIN7
4630: where ROWID in (select STG_ROWID
4631: from PJI_PJP_RMAP_FPR
4632: where WORKER_ID = p_worker_id);
4633:
4634: end if;
4635:

Line 4677: from PJI_PJP_RMAP_FPR tmp7_r,

4673: delete
4674: from PJI_FP_TXN_ACCUM1 bal
4675: where bal.PROJECT_ID in (select distinct
4676: fin7.PROJECT_ID
4677: from PJI_PJP_RMAP_FPR tmp7_r,
4678: PJI_FM_AGGR_FIN7 fin7
4679: where tmp7_r.WORKER_ID = p_worker_id and
4680: tmp7_r.RECORD_TYPE = 'M' and
4681: fin7.ROWID = tmp7_r.STG_ROWID);

Line 4815: PJI_PJP_RMAP_FPR tmp7_r,

4811: l_created_by CREATED_BY,
4812: l_last_update_login LAST_UPDATE_LOGIN,
4813: cbs_element_id cbs_element_id
4814: from
4815: PJI_PJP_RMAP_FPR tmp7_r,
4816: PJI_FM_AGGR_FIN7 tmp7
4817: where
4818: tmp7_r.WORKER_ID = p_worker_id and
4819: tmp7_r.TXN_ROWID is null and