VIEW: APPS.XTR_INTERGROUP_TRANSFERS_V

Source

View Text - Preformatted

SELECT DEAL_NUMBER, FIRST_BATCH_ID, LAST_BATCH_ID, EXCHANGE_RATE, TRANSACTION_NUMBER, DEAL_TYPE, TRANSFER_DATE, COMPANY_CODE, PARTY_CODE, CURRENCY, NO_OF_DAYS, BALANCE_OUT, BALANCE_OUT_HCE, BALANCE_BF, BALANCE_BF_HCE, ACCUM_INTEREST_BF, ACCUM_INTEREST_BF_HCE, PRINCIPAL_ADJUST, PRINCIPAL_ADJUST_HCE, PRINCIPAL_ACTION, COMPANY_ACCOUNT_NO, PARTY_ACCOUNT_NO, INTEREST_RATE, INTEREST, INTEREST_HCE, INTEREST_SETTLED, INTEREST_SETTLED_HCE, CREATED_BY, CREATED_ON, SETTLE_DATE, UPDATED_BY, UPDATED_ON, PRODUCT_TYPE, AUDIT_INDICATOR, COMMENTS, LIMIT_CODE, PORTFOLIO, ACCT_REF, ACCRUAL_INTEREST, AVERAGE_EXCHANGE_RATE, INTEREST_ACTION, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, EXTERNAL_DEAL_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LIMIT_CODE_INVEST, MIRROR_DEAL, MIRROR_DEAL_NUMBER, MIRROR_TRANSACTION_NUMBER, DAY_COUNT_TYPE, ROUNDING_TYPE, ORIGINAL_AMOUNT, PRICING_MODEL, DEAL_LINKING_CODE, DEALER_CODE FROM XTR_INTERGROUP_TRANSFERS

View Text - HTML Formatted

SELECT DEAL_NUMBER
, FIRST_BATCH_ID
, LAST_BATCH_ID
, EXCHANGE_RATE
, TRANSACTION_NUMBER
, DEAL_TYPE
, TRANSFER_DATE
, COMPANY_CODE
, PARTY_CODE
, CURRENCY
, NO_OF_DAYS
, BALANCE_OUT
, BALANCE_OUT_HCE
, BALANCE_BF
, BALANCE_BF_HCE
, ACCUM_INTEREST_BF
, ACCUM_INTEREST_BF_HCE
, PRINCIPAL_ADJUST
, PRINCIPAL_ADJUST_HCE
, PRINCIPAL_ACTION
, COMPANY_ACCOUNT_NO
, PARTY_ACCOUNT_NO
, INTEREST_RATE
, INTEREST
, INTEREST_HCE
, INTEREST_SETTLED
, INTEREST_SETTLED_HCE
, CREATED_BY
, CREATED_ON
, SETTLE_DATE
, UPDATED_BY
, UPDATED_ON
, PRODUCT_TYPE
, AUDIT_INDICATOR
, COMMENTS
, LIMIT_CODE
, PORTFOLIO
, ACCT_REF
, ACCRUAL_INTEREST
, AVERAGE_EXCHANGE_RATE
, INTEREST_ACTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, EXTERNAL_DEAL_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LIMIT_CODE_INVEST
, MIRROR_DEAL
, MIRROR_DEAL_NUMBER
, MIRROR_TRANSACTION_NUMBER
, DAY_COUNT_TYPE
, ROUNDING_TYPE
, ORIGINAL_AMOUNT
, PRICING_MODEL
, DEAL_LINKING_CODE
, DEALER_CODE
FROM XTR_INTERGROUP_TRANSFERS