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.XTR_AUTO_RECONCILIATION dependencies on XTR_DEAL_DATE_AMOUNTS_V

Line 327: from XTR_DEAL_DATE_AMOUNTS_V dda

323: ---------
324: CURSOR DDA_REC_ROW is
325: select dda.DEAL_NUMBER, dda.TRANSACTION_NUMBER, dda.AMOUNT, dda.AMOUNT_DATE,
326: dda.RECONCILED_REFERENCE,substr(dda.RECONCILED_PASS_CODE,2) ---reset
327: from XTR_DEAL_DATE_AMOUNTS_V dda
328: where dda.RECONCILED_REFERENCE between
329: nvl(L_MIN_REC_NOS,9999999) and nvl(L_MAX_REC_NOS,0)
330: and dda.DEAL_TYPE = 'RTMM'
331: and nvl(dda.amount,0) <>0

Line 710: from xtr_deal_date_amounts_v

706: -- Bug 4226409
707: cursor cur_settle_detail is
708: select actual_settlement_date,settlement_number,deal_type,trans_mts
709: ,settlement_authorised_by,audit_indicator
710: from xtr_deal_date_amounts_v
711: where deal_number = l_deal_no
712: and transaction_number = pmt.transaction_number
713: and amount_type = 'INTSET';
714:

Line 1022: update XTR_DEAL_DATE_AMOUNTS_V

1018: null;
1019: End if;
1020: --
1021: -- Update Interest Amounts
1022: update XTR_DEAL_DATE_AMOUNTS_V
1023: set AMOUNT = round(decode(nvl(pmt.PI_AMOUNT_RECEIVED,0)
1024: ,0,nvl(pmt.PI_AMOUNT_DUE,0)
1025: ,nvl(pmt.INTEREST_SETTLED,0)),
1026: rounding_fac),

Line 1053: update XTR_DEAL_DATE_AMOUNTS_V

1049: End if;
1050: --
1051: -- Principal Repayment has/will ocurr ???
1052: if nvl(l_prin_decr,0)<>0 then
1053: update XTR_DEAL_DATE_AMOUNTS_V
1054: set AMOUNT = decode(nvl(AMOUNT,0),0,nvl(l_prin_decr,0),AMOUNT),
1055: HCE_AMOUNT = decode(nvl(HCE_AMOUNT,0),0,hce_decr,HCE_AMOUNT),
1056: AMOUNT_DATE = nvl(pmt.SETTLE_DATE,pmt.MATURITY_DATE),
1057: DATE_TYPE = decode(nvl(pmt.PI_AMOUNT_RECEIVED,0),0,'FORCAST','SETTLE'),

Line 1076: update XTR_DEAL_DATE_AMOUNTS_V

1072: fetch cur_settle_detail into l_settle_date,l_settle_number,l_deal_type
1073: ,l_trans_mts,l_settle_by,l_audit_indicator;
1074: if(l_deal_type = 'RTMM') then
1075: close cur_settle_detail;
1076: update XTR_DEAL_DATE_AMOUNTS_V
1077: set SETTLEMENT_NUMBER = l_settle_number,
1078: ACTUAL_SETTLEMENT_DATE = l_settle_date,
1079: TRANS_MTS = l_trans_mts,
1080: SETTLEMENT_AUTHORISED_BY = l_settle_by,

Line 1095: delete from XTR_DEAL_DATE_AMOUNTS_V

1091: End if;
1092: --
1093: end if;
1094: if nvl(pmt.PRINCIPAL_ADJUST,0) = 0 then
1095: delete from XTR_DEAL_DATE_AMOUNTS_V
1096: where DEAL_NUMBER = l_deal_no
1097: and TRANSACTION_NUMBER = pmt.TRANSACTION_NUMBER
1098: and AMOUNT_TYPE in ('PRINFLW')
1099: and ACTION_CODE = 'INCRSE';

Line 1119: UPDATE XTR_DEAL_DATE_AMOUNTS_V

1115: End if;
1116: end if;
1117:
1118: -- Update BALOUT Amounts
1119: UPDATE XTR_DEAL_DATE_AMOUNTS_V
1120: set AMOUNT = nvl(pmt.BALANCE_OUT,0),
1121: HCE_AMOUNT = hce_balos
1122: where DEAL_NUMBER = l_deal_no
1123: and DEAL_TYPE='RTMM'

Line 1132: insert into XTR_DEAL_DATE_AMOUNTS_V

1128:
1129: if SQL%NOTFOUND then
1130: -- Add 1 more row to DDA for Balout
1131:
1132: insert into XTR_DEAL_DATE_AMOUNTS_V
1133: (deal_type,amount_type,date_type,
1134: deal_number,transaction_number,transaction_date,currency,
1135: amount,hce_amount,amount_date,transaction_rate,
1136: cashflow_amount,company_code,account_no,action_code,

Line 1272: from XTR_DEAL_DATE_AMOUNTS_V

1268: /* modified the cursor to differentiate non-netted records from netted records. incase of netted records, we need to
1269: look at the netted amount. */
1270: cursor DDA is
1271: select sum(round(CASHFLOW_AMOUNT,2)),count(*),AMOUNT_DATE, NETOFF_NUMBER
1272: from XTR_DEAL_DATE_AMOUNTS_V
1273: where ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1274: and nvl(l_deal_no,'N') = 'Y')
1275: or (l_deal_no is NULL )) --- modify
1276: and ((AMOUNT_DATE between (rec_det.VALUE_DATE - l_days) and

Line 1307: from XTR_DEAL_DATE_AMOUNTS_V

1303: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N') ='Y')
1304: group by AMOUNT_DATE, NETOFF_NUMBER
1305: union all
1306: select sum(round(CASHFLOW_AMOUNT,2)),count(distinct NETOFF_NUMBER),AMOUNT_DATE, NETOFF_NUMBER
1307: from XTR_DEAL_DATE_AMOUNTS_V
1308: where
1309: /*
1310: ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1311: and nvl(l_deal_no,'N') = 'Y')

Line 1350: from XTR_DEAL_DATE_AMOUNTS_V

1346: /***************** CE Recon project **********************/
1347: /* non-netted records are summed up, while netted records are summed by the netoff_number */
1348: cursor DDA_SUM_DATE is
1349: select AMOUNT_DATE,sum(round(CASHFLOW_AMOUNT,2)),count(distinct nvl(NETOFF_NUMBER, -1)), NETOFF_NUMBER
1350: from XTR_DEAL_DATE_AMOUNTS_V
1351: where ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1352: and nvl(l_deal_no,'N') = 'Y')
1353: or (l_deal_no is NULL and date_type <> 'FORCAST'))
1354: and (((AMOUNT_DATE between (rec_det.VALUE_DATE - l_days) and

Line 1381: from XTR_DEAL_DATE_AMOUNTS_V

1377: /************* CE Recon proejct *************/
1378: /* netted records and non-netted records are dealt with separately*/
1379: cursor DDA_SUM_RANGE is
1380: select sum(round(CASHFLOW_AMOUNT,2)),count(distinct nvl(netoff_number, -1)), Netoff_number
1381: from XTR_DEAL_DATE_AMOUNTS_V
1382: where ((to_char(DEAL_NUMBER) = ltrim(rtrim(rec_det.PARTICULARS))
1383: and nvl(l_deal_no,'N') = 'Y')
1384: or (l_deal_no is NULL and date_type<>'FORCAST'))
1385: and (((AMOUNT_DATE between (rec_det.VALUE_DATE - l_days) and