DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_INTERGROUP_TRANSFERS_V

Object Details
Object Name: XTR_INTERGROUP_TRANSFERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_INTERGROUP_TRANSFERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEAL_NUMBER NUMBER
Yes Unique number assigned to each deal
FIRST_BATCH_ID NUMBER (15)
First batch id. Identifier that groups events into one process flow.
LAST_BATCH_ID NUMBER (15)
Last batch id. Identifier that groups events into one process flow.
EXCHANGE_RATE NUMBER

Exchange rate.
TRANSACTION_NUMBER NUMBER
Yes Unique reference number assigned to a transaction
DEAL_TYPE VARCHAR2 (7) Yes Code for high level deals
TRANSFER_DATE DATE
Yes Date the transfer occurred
COMPANY_CODE VARCHAR2 (7) Yes Company code
PARTY_CODE VARCHAR2 (7) Yes Party code
CURRENCY VARCHAR2 (15) Yes Currency code
NO_OF_DAYS NUMBER

Number of days
BALANCE_OUT NUMBER

Balance amount
BALANCE_OUT_HCE NUMBER

Balance amount in reporting currency equivalent
BALANCE_BF NUMBER

Previous balance brought forward
BALANCE_BF_HCE NUMBER

Previous balance brought forward in reporting currency equivalent
ACCUM_INTEREST_BF NUMBER

Accumulated interest
ACCUM_INTEREST_BF_HCE NUMBER

Accumulated interest in reporting currency equivalent
PRINCIPAL_ADJUST NUMBER

Principal adjustment amount
PRINCIPAL_ADJUST_HCE NUMBER

Principal adjustment amount in reporting currency equivalent
PRINCIPAL_ACTION VARCHAR2 (7)
Indicates if a principal is paid (PAY) or received (REC)
COMPANY_ACCOUNT_NO VARCHAR2 (20)
Company financial account number
PARTY_ACCOUNT_NO VARCHAR2 (20)
Counterparty financial account number
INTEREST_RATE NUMBER

Interest rate at which a deal or transaction is executed
INTEREST NUMBER

Interest amount
INTEREST_HCE NUMBER

Interest amount in reporting currency equivalent
INTEREST_SETTLED NUMBER

Interest settlement
INTEREST_SETTLED_HCE NUMBER

Interest settlement in reporting currency equivalent
CREATED_BY VARCHAR2 (30)
User who created this record
CREATED_ON DATE

Date this record was created
SETTLE_DATE DATE

Date the transfer is settled
UPDATED_BY VARCHAR2 (30)
User who last updated this record
UPDATED_ON DATE

Date this record was last updated
PRODUCT_TYPE VARCHAR2 (10)
Code for products used in a deal type
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
COMMENTS VARCHAR2 (255)
Comments
LIMIT_CODE VARCHAR2 (7)
Code for user-defined limits imposed on deals and transactions
PORTFOLIO VARCHAR2 (7)
Code for grouping deals under a single portfolio
ACCT_REF VARCHAR2 (7)
Account reference
ACCRUAL_INTEREST NUMBER

Running accumulated interest
AVERAGE_EXCHANGE_RATE NUMBER

Average exchange rate.
INTEREST_ACTION VARCHAR2 (1)
This column stores interest action. Possible values are 'C'=compound, 'S'=settle, 'N'=none.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
For Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
EXTERNAL_DEAL_ID VARCHAR2 (240)
Stores the unique external primary
REQUEST_ID NUMBER

The concurrent request that created or updated the row.
PROGRAM_APPLICATION_ID NUMBER

With PROGRAM_ID, identifies the concurrent program that created or updated the row.
PROGRAM_ID NUMBER

With PROGRAM_APPLICATION_ID, identifies the concurrent program that created or updated the row.
PROGRAM_UPDATE_DATE DATE

The date when the concurrent program created or updated the row.
LIMIT_CODE_INVEST VARCHAR2 (7)
The user-defined invest limit types assigned to the deal or transaction.
MIRROR_DEAL VARCHAR2 (1)
Indicates if this is a mirror deal or not.
MIRROR_DEAL_NUMBER NUMBER (38)
Indicates the mirror deal number.
MIRROR_TRANSACTION_NUMBER NUMBER (38)
Indicates the mirror transaction number.
DAY_COUNT_TYPE VARCHAR2 (1)
Not currently used
ROUNDING_TYPE VARCHAR2 (1)
Not currently used
ORIGINAL_AMOUNT NUMBER

Not currently used
PRICING_MODEL VARCHAR2 (30)
Intercompany Funding pricing model
DEAL_LINKING_CODE VARCHAR2 (8)
Code to identify the group of linked deals
DEALER_CODE VARCHAR2 (10) Yes Code for Treasury users
Query Text

Cut, paste (and edit) the following text to query this object:


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 APPS.XTR_INTERGROUP_TRANSFERS_V;

Dependencies

[top of page]

APPS.XTR_INTERGROUP_TRANSFERS_V references the following:

SchemaAPPS
SynonymXTR_INTERGROUP_TRANSFERS
APPS.XTR_INTERGROUP_TRANSFERS_V is referenced by following:

SchemaAPPS
Package BodyXTR_IG_TRANSFERS_PKG - show dependent code
Package BodyXTR_REVAL_PROCESS_P - show dependent code
Package BodyXTR_WORKFLOW_PKG - show dependent code
Package BodyXTR_WRAPPER_API_P - show dependent code