Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_INTERGROUP_TRANSFERS_V |
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