Product: | XTR - Treasury |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.XTR_R_ROLLOVER_TRANSACTIONS_V |
SELECT INTEREST_SETTLED
, INTEREST_SETTLEMENT_TYPE
, INTERNAL_TICKET_NO
, ISSUER_ADVICE
, LIMIT_CODE
, MATURITY_DATE
, NI_PROFIT_LOSS
, NI_PROFIT_LOSS_HCE
, NI_RENEG_DATE
, NO_OF_DAYS
, OLD_PRODUCT_TYPE
, PARCEL_SPLIT_NO
, PARENT_PARTY
, PI_AMOUNT_DUE
, PI_AMOUNT_RECEIVED
, PORTFOLIO_CODE
, PRINCIPAL_ACCOUNT_NO
, PRINCIPAL_ACTION
, PRINCIPAL_ADJUST
, PRINCIPAL_ADJUST_HCE
, PRINCIPAL_AMOUNT_TYPE
, PRINTED_CPARTY_ADVICE
, PRINTED_REDEMPTION_YN
, PRINTED_YN
, PRODUCT_TYPE
, QUICK_INPUT
, RATE_EFFECTIVE_CREATED
, RENEG_ONLY_LETTER
, REPAY_AMOUNT
, REPAY_AMOUNT_HCE
, SECURITY_TYPE
, SETTLEMENT_TYPE
, SETTLE_DATE
, SETTLE_TERM_INTEREST
, START_DATE
, STATUS_CODE
, TAX_AMOUNT
, TAX_AMOUNT_HCE
, TAX_CODE
, TAX_RATE
, TAX_SETTLED_REFERENCE
, TRANSACTION_NUMBER
, TRANS_CLOSEOUT_NO
, UPDATED_BY
, UPDATED_ON
, YEAR_BASIS
, YEAR_CALC_TYPE
, ACCEPTOR_CODE
, ACCEPTOR_NAME
, ACCRUAL_FROM
, ACCRUAL_TO
, ACCUM_INTEREST
, ACCUM_INTEREST_BF
, ACCUM_INTEREST_BF_HCE
, ACCUM_INTEREST_HCE
, ACCUM_INT_ACCOUNT_NO
, ACCUM_INT_ACTION
, ACCUM_INT_AMOUNT_TYPE
, ACTION_STATUS
, ADJUSTED_BALANCE
, ARCHIVE_BY
, ARCHIVE_DATE
, ATTACHMENT_EXISTS
, AUDIT_INDICATOR
, BALANCE_OUT
, BALANCE_OUT_BF
, BALANCE_OUT_BF_HCE
, BALANCE_OUT_HCE
, BAL_OS_ACCOUNT_NO
, BKGE_SETTLED_REFERENCE
, BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE
, BROKERAGE_RATE
, CLIENT_ADVICE
, CLIENT_CODE
, COMMENTS
, COMPANY_CODE
, CPARTY_ADVICE
, CPARTY_CODE
, CREATED_BY
, CREATED_ON
, CROSS_REF_TO_TRANS
, CURRENCY
, DATE_RECEIVED
, DEALER_CODE
, DEAL_DATE
, DEAL_LINKING_CODE
, DEAL_NUMBER
, DEAL_SUBTYPE
, DEAL_TYPE
, DRAWER_CODE
, DRAWER_NAME
, DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON
, ENDORSER_CODE
, ENDORSER_NAME
, EXPECTED_BALANCE_BF
, EXPECTED_BALANCE_OUT
, EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO
, FID_TAX
, FID_TAX_HCE
, INTEREST
, INTEREST_FREQ
, INTEREST_HCE
, INTEREST_RATE
, RATE_FIXING_DATE
FROM XTR_R_ROLLOVER_TRANSACTIONS