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

VIEW: APPS.XTR_LINKED_TRANSACTIONS_V

Object Details
Object Name: XTR_LINKED_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_LINKED_TRANSACTIONS_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_LINKING_CODE VARCHAR2 (8)
DEAL_NUM NUMBER

TRANS_NUM NUMBER

CPARTY_CODE VARCHAR2 (7)
CLIENT_CODE VARCHAR2 (7)
COMPANY_CODE VARCHAR2 (7)
DEAL_TYPE VARCHAR2 (7)
USER_DEAL_TYPE VARCHAR2 (7)
User-defined deal type code
DEAL_SUBTYPE VARCHAR2 (7)
USER_DEAL_SUBTYPE VARCHAR2 (7)
User-defined deal subtype code
PRODUCT_TYPE VARCHAR2 (10)
DEAL_DATE DATE

CURRENCY_BUY VARCHAR2 (15)
CURRENCY_SELL VARCHAR2 (15)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

Query Text

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


SELECT DEAL_LINKING_CODE
,      DEAL_NUM
,      TRANS_NUM
,      CPARTY_CODE
,      CLIENT_CODE
,      COMPANY_CODE
,      DEAL_TYPE
,      USER_DEAL_TYPE
,      DEAL_SUBTYPE
,      USER_DEAL_SUBTYPE
,      PRODUCT_TYPE
,      DEAL_DATE
,      CURRENCY_BUY
,      CURRENCY_SELL
,      UPDATED_BY
,      UPDATED_ON
FROM APPS.XTR_LINKED_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.XTR_LINKED_TRANSACTIONS_V references the following:

SchemaAPPS
ViewXTR_DEALS_V
SynonymXTR_DEAL_SUBTYPES
SynonymXTR_DEAL_TYPES
ViewXTR_EXPOSURE_TRANSACTIONS_V
SynonymXTR_INTERGROUP_TRANSFERS
ViewXTR_ROLLOVER_TRANSACTIONS_V
PL/SQL PackageXTR_USER_ACCESS - show dependent code

APPS.XTR_LINKED_TRANSACTIONS_V is not referenced by any database object