APPS.XTR_EXP_SUMM_P dependencies on XTR_DEAL_DATE_AMOUNTS_V

Line 39: from XTR_DEAL_DATE_AMOUNTS_V

35: ,to_char(AMOUNT_DATE,'MON-YYYY')),AMOUNT_DATE,
36: sum(CASHFLOW_AMOUNT),CURRENCY_COMBINATION,sum(TRANSACTION_RATE),
37: decode(DEAL_TYPE,'FX',TRANSACTION_NUMBER,'FXO',TRANSACTION_NUMBER,1),
38: decode(DEAL_TYPE,'FX',nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),'FXO',nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),NULL),count(AMOUNT)
39: from XTR_DEAL_DATE_AMOUNTS_V
40: where STATUS_CODE = 'CURRENT'
41: and (AMOUNT_DATE >= trunc(SYSDATE) or EXPOSURE_REF_DATE >=trunc(SYSDATE))
42: and COMPANY_CODE = l_company
43: and CASHFLOW_AMOUNT <> 0

Line 70: from XTR_DEAL_DATE_AMOUNTS_V d,

66: -- eg INVEST initial cflow is -ve therefore show as cash on hand (+ve)
67: --
68: cursor GET_ONC_BALS is
69: select sum((-1) * d.cashflow_amount) CASH_ON_HAND
70: from XTR_DEAL_DATE_AMOUNTS_V d,
71: XTR_ROLLOVER_TRANSACTIONS_V r
72: where d.STATUS_CODE = 'CURRENT'
73: and d.DEAL_TYPE = 'ONC'
74: and d.COMPANY_CODE = l_company

Line 225: from XTR_DEAL_DATE_AMOUNTS_V

221: nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),
222: sum(CASHFLOW_AMOUNT),
223: CURRENCY_COMBINATION,sum(TRANSACTION_RATE),
224: TRANSACTION_NUMBER,nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),count(AMOUNT)
225: from XTR_DEAL_DATE_AMOUNTS_V
226: where STATUS_CODE = 'CURRENT'
227: and CURRENCY_COMBINATION like upper(nvl(l_ccy_a,'%'))||'/'||upper(nvl(l_ccy_b,'%'))
228: and (AMOUNT_DATE >= trunc(SYSDATE) or EXPOSURE_REF_DATE >=trunc(sysdate))
229: and CURRENCY = substr(CURRENCY_COMBINATION,1,3)

Line 478: from XTR_DEAL_DATE_AMOUNTS_V

474: select CURRENCY,to_char(nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),'DD-MM-YYYY'),sum(CASHFLOW_AMOUNT),
475: CURRENCY_COMBINATION,sum(TRANSACTION_RATE),
476: decode(DEAL_TYPE,'FX',TRANSACTION_NUMBER,'FXO',TRANSACTION_NUMBER,1),
477: decode(DEAL_TYPE,'FX',nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),'FXO',nvl(EXPOSURE_REF_DATE,AMOUNT_DATE),NULL),count(AMOUNT)
478: from XTR_DEAL_DATE_AMOUNTS_V
479: where STATUS_CODE = 'CURRENT'
480: and (AMOUNT_DATE >= trunc(SYSDATE)
481: or EXPOSURE_REF_DATE >=trunc(SYSDATE))
482: and COMPANY_CODE = l_company

Line 498: from XTR_DEAL_DATE_AMOUNTS_V

494: select CURRENCY,to_char(AMOUNT_DATE,'DD-MM-YYYY'),sum(CASHFLOW_AMOUNT),
495: CURRENCY_COMBINATION,sum(TRANSACTION_RATE),
496: decode(DEAL_TYPE,'FX',TRANSACTION_NUMBER,'FXO',TRANSACTION_NUMBER,1),
497: decode(DEAL_TYPE,'FX',AMOUNT_DATE,'FXO',AMOUNT_DATE,NULL),count(AMOUNT)
498: from XTR_DEAL_DATE_AMOUNTS_V
499: where STATUS_CODE = 'CURRENT'
500: and AMOUNT_DATE >= trunc(SYSDATE)
501: and COMPANY_CODE = l_company
502: and ((deal_type='EXP' and perspective='^') or perspective <>'^')

Line 530: from XTR_DEAL_DATE_AMOUNTS_V d,

526: -- eg INVEST initial cflow is -ve therefore show as cash on hand (+ve)
527: --
528: cursor GET_ONC_BALS is
529: select d.currency,sum((-1) * d.cashflow_amount) CASH_ON_HAND
530: from XTR_DEAL_DATE_AMOUNTS_V d,
531: XTR_ROLLOVER_TRANSACTIONS_V r
532: where d.STATUS_CODE = 'CURRENT'
533: and d.DEAL_TYPE = 'ONC'
534: and d.COMPANY_CODE = l_company