View: XTR_ROLLOVER_TRANSACTIONS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_ROLLOVER_TRANSACTIONS_V

View Text

SELECT XD.INTEREST_FREQ
, XD.INTEREST_HCE
, XD.INTEREST_RATE
, XD.INTEREST_SETTLED
, XD.INTEREST_SETTLEMENT_TYPE
, XD.INTERNAL_TICKET_NO
, XD.ISSUER_ADVICE
, XD.LIMIT_CODE
, XD.MATURITY_DATE
, XD.NI_PROFIT_LOSS
, XD.NI_PROFIT_LOSS_HCE
, XD.NI_RENEG_DATE
, XD.NO_OF_DAYS
, XD.OLD_PRODUCT_TYPE
, XD.PARCEL_SPLIT_NO
, XD.PARENT_PARTY
, XD.PI_AMOUNT_DUE
, XD.PI_AMOUNT_RECEIVED
, XD.PORTFOLIO_CODE
, XD.PRINCIPAL_ACCOUNT_NO
, XD.PRINCIPAL_ACTION
, XD.PRINCIPAL_ADJUST
, XD.PRINCIPAL_ADJUST_HCE
, XD.PRINCIPAL_AMOUNT_TYPE
, XD.PRINTED_CPARTY_ADVICE
, XD.PRINTED_REDEMPTION_YN
, XD.PRINTED_YN
, XD.PRODUCT_TYPE
, XD.QUICK_INPUT
, XD.RATE_EFFECTIVE_CREATED
, XD.RENEG_ONLY_LETTER
, XD.REPAY_AMOUNT
, XD.REPAY_AMOUNT_HCE
, XD.SECURITY_TYPE
, XD.SETTLEMENT_TYPE
, XD.SETTLE_DATE
, XD.SETTLE_TERM_INTEREST
, XD.START_DATE
, XD.STATUS_CODE
, XD.TAX_AMOUNT
, XD.TAX_AMOUNT_HCE
, XD.TAX_CODE
, XD.TAX_RATE
, XD.TAX_SETTLED_REFERENCE
, XD.PRINCIPAL_TAX_CODE
, XD.PRINCIPAL_TAX_RATE
, XD.PRINCIPAL_TAX_AMOUNT
, XD.PRINCIPAL_TAX_SETTLED_REF
, XD.TRANSACTION_NUMBER
, XD.TRANS_CLOSEOUT_NO
, XD.UPDATED_BY
, XD.UPDATED_ON
, XD.YEAR_BASIS
, XD.YEAR_CALC_TYPE
, XD.ACCEPTOR_CODE
, XD.ACCEPTOR_NAME
, XD.ACCRUAL_FROM
, XD.ACCRUAL_TO
, XD.ACCUM_INTEREST
, XD.ACCUM_INTEREST_BF
, XD.ACCUM_INTEREST_BF_HCE
, XD.ACCUM_INTEREST_HCE
, XD.ACCUM_INT_ACCOUNT_NO
, XD.ACCUM_INT_ACTION
, XD.ACCUM_INT_AMOUNT_TYPE
, XD.ACTION_STATUS
, XD.ADJUSTED_BALANCE
, XD.ARCHIVE_BY
, XD.ARCHIVE_DATE
, XD.ATTACHMENT_EXISTS
, XD.AUDIT_INDICATOR
, XD.BALANCE_OUT
, XD.BALANCE_OUT_BF
, XD.BALANCE_OUT_BF_HCE
, XD.BALANCE_OUT_HCE
, XD.BAL_OS_ACCOUNT_NO
, XD.BKGE_SETTLED_REFERENCE
, XD.BROKERAGE_AMOUNT
, XD.BROKERAGE_AMOUNT_HCE
, XD.BROKERAGE_CODE
, XD.BROKERAGE_RATE
, XD.CLIENT_ADVICE
, XD.CLIENT_CODE
, XD.COMMENTS
, XD.COMPANY_CODE
, XD.CPARTY_ADVICE
, XD.CPARTY_CODE
, XD.CREATED_BY
, XD.CREATED_ON
, XD.CROSS_REF_TO_TRANS
, XD.CURRENCY
, XD.DATE_RECEIVED
, XD.DEALER_CODE
, XD.DEAL_DATE
, XD.DEAL_LINKING_CODE
, XD.DEAL_NUMBER
, XD.DEAL_SUBTYPE
, XD.DEAL_TYPE
, XD.DRAWER_CODE
, XD.DRAWER_NAME
, XD.DUAL_AUTHORISATION_BY
, XD.DUAL_AUTHORISATION_ON
, XD.ENDORSER_CODE
, XD.ENDORSER_NAME
, XD.EXPECTED_BALANCE_BF
, XD.EXPECTED_BALANCE_OUT
, XD.EXTERNAL_COMMENTS
, XD.EXTERNAL_CPARTY_NO
, XD.FID_TAX
, XD.FID_TAX_HCE
, XD.INTEREST
, XD.RATE_FIXING_DATE
, XD.FIRST_REVAL_BATCH_ID
, XD.LAST_REVAL_BATCH_ID
, XD.CURRENCY_EXCHANGE_RATE
, XD.INITIAL_FAIR_VALUE
, XD.ALL_IN_RATE
, XD.AVERAGE_EXCHANGE_RATE
, XD.BACK_END_BROKERAGE_AMOUNT
, XD.QUANTITY
, XD.ATTRIBUTE_CATEGORY
, XD.ATTRIBUTE1
, XD.ATTRIBUTE2
, XD.ATTRIBUTE3
, XD.ATTRIBUTE4
, XD.ATTRIBUTE5
, XD.ATTRIBUTE6
, XD.ATTRIBUTE7
, XD.ATTRIBUTE8
, XD.ATTRIBUTE9
, XD.ATTRIBUTE10
, XD.ATTRIBUTE11
, XD.ATTRIBUTE12
, XD.ATTRIBUTE13
, XD.ATTRIBUTE14
, XD.ATTRIBUTE15
, ORIG_COUPON_AMOUNT
, XD.ORIGINAL_AMOUNT
, XD.FIRST_TRANSACTION_FLAG
, XD.PREPAID_INTEREST
, XD.INTEREST_REFUND
, XD.ORG_TRANS_NO
, XD.COUPON_DUE_DATE
FROM XTR_ROLLOVER_TRANSACTIONS XD
WHERE COMPANY_CODE IN (SELECT XCA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES XCA
WHERE XCA.DEALER_CODE = XTR_USER_ACCESS.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' )

Columns