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


VIEW: APPS.XTR_A_DEAL_ORDERS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIQUE_REF_NUM NUMBER
Yes
DEAL_TYPE VARCHAR2 (7) Yes
ORDER_TYPE VARCHAR2 (7) Yes
COMPANY_CODE VARCHAR2 (7) Yes
CPARTY_CODE VARCHAR2 (7) Yes
STATUS_CODE VARCHAR2 (10) Yes
PLACED_ON DATE
Yes
VALID_UNTIL DATE
Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
DETAILS_OF_ORDER VARCHAR2 (255) Yes
CONFIRMED_BY_DEALER VARCHAR2 (10)
DEAL_SUBTYPE VARCHAR2 (7)
PRODUCT_TYPE VARCHAR2 (10)
DEALER_COMPANY VARCHAR2 (10)
DEALER_CPARTY VARCHAR2 (10)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

ORDER_RATE NUMBER

ORDER_CCY_A VARCHAR2 (1)
CCY_A_AMOUNT NUMBER

ORDER_CCY_B VARCHAR2 (1)
CCY_B_AMOUNT NUMBER

ORDER_DELIVERY_DATE DATE

SOURCE VARCHAR2 (20)
RIC_CODE VARCHAR2 (20)
ADVICE_GROUP VARCHAR2 (7)
ORDER_GROUP VARCHAR2 (7)
GROUP_ACTION VARCHAR2 (7)
ABOVE_OR_BELOW_LEVEL VARCHAR2 (7)
MARKET_RATE_WHEN_ENTERED NUMBER

CROSS_REF NUMBER

AUDIT_INDICATOR VARCHAR2 (1)
AUDIT_DATE_STORED DATE

Query Text

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


SELECT UNIQUE_REF_NUM
,      DEAL_TYPE
,      ORDER_TYPE
,      COMPANY_CODE
,      CPARTY_CODE
,      STATUS_CODE
,      PLACED_ON
,      VALID_UNTIL
,      CREATED_BY
,      CREATED_ON
,      DETAILS_OF_ORDER
,      CONFIRMED_BY_DEALER
,      DEAL_SUBTYPE
,      PRODUCT_TYPE
,      DEALER_COMPANY
,      DEALER_CPARTY
,      UPDATED_BY
,      UPDATED_ON
,      ORDER_RATE
,      ORDER_CCY_A
,      CCY_A_AMOUNT
,      ORDER_CCY_B
,      CCY_B_AMOUNT
,      ORDER_DELIVERY_DATE
,      SOURCE
,      RIC_CODE
,      ADVICE_GROUP
,      ORDER_GROUP
,      GROUP_ACTION
,      ABOVE_OR_BELOW_LEVEL
,      MARKET_RATE_WHEN_ENTERED
,      CROSS_REF
,      AUDIT_INDICATOR
,      AUDIT_DATE_STORED
FROM APPS.XTR_A_DEAL_ORDERS_V;

Dependencies

[top of page]

APPS.XTR_A_DEAL_ORDERS_V references the following:

SchemaAPPS
SynonymXTR_A_DEAL_ORDERS

APPS.XTR_A_DEAL_ORDERS_V is not referenced by any database object