View: XTR_DISC_ACCRLS_AMORT_V

Product:	XTR - Treasury
Description:	Accruals amounts for deals and transactions, where user access to company information is enforced.
Implementation/DBA Data:	APPS.XTR_DISC_ACCRLS_AMORT_V

View Text

SELECT AC.DEAL_NO
, AC.BATCH_ID
, AC.TRANS_NO
, AC.PERIOD_FROM
, AC.PERIOD_TO
, AC.COMPANY_CODE
, DT.USER_DEAL_TYPE
, ST.USER_DEAL_SUBTYPE
, AC.CPARTY_CODE
, AC.CURRENCY
, AC.PRODUCT_TYPE
, AC.PORTFOLIO_CODE
, AC.AMOUNT_TYPE
, AC.ACTION_CODE
, AC.TRANSACTION_AMOUNT
, AC.ACTUAL_START_DATE
, AC.ACTUAL_MATURITY_DATE
, AC.INTEREST_RATE
, AC.NO_OF_DAYS
, AC.YEAR_BASIS
, AC.ACCRLS_AMOUNT
, AC.FIRST_ACCRUAL_INDIC
, AC.ACCRLS_AMOUNT_BAL
, AC.EFFECTIVE_CALCULATED_VALUE
, AC.CALC_FACE_VALUE
, AC.EFFINT_ACCRLS_AMOUNT_BAL
, PI1.FULL_NAME COMPANY_NAME
, DT.NAME DEAL_TYPE_NAME
, ST.NAME DEAL_SUBTYPE_NAME
, PI2.FULL_NAME CPARTY_NAME
, P.PRODUCT_DESC PRODUCT_TYPE_DESC
FROM XTR_ACCRLS_AMORT AC
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PRODUCT_TYPES P
, XTR_PARTY_INFO PI1
, XTR_PARTY_INFO PI2
WHERE DT.DEAL_TYPE = AC.DEAL_TYPE
AND (ST.DEAL_TYPE = AC.DEAL_TYPE
AND ST.DEAL_SUBTYPE = AC.DEAL_SUBTYPE)
AND (P.DEAL_TYPE(+) = AC.DEAL_TYPE
AND P.PRODUCT_TYPE(+) = AC.PRODUCT_TYPE)
AND PI1.PARTY_CODE = AC.COMPANY_CODE
AND PI2.PARTY_CODE(+) = AC.CPARTY_CODE
AND AC.COMPANY_CODE=XCA.PARTY_CODE
AND XCA.DEALER_CODE=XDC.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND XDC.USER_ID=FND_GLOBAL.USER_ID

Columns