VIEW: APPS.XTR_ROLLOVER_TRANSACTIONS_V

Source

View Text - Preformatted

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' )

View Text - HTML Formatted

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' )