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


VIEW: APPS.XTR_FX_ROLL_PRE_DETAILS_V

Object Details
Object Name: XTR_FX_ROLL_PRE_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_FX_ROLL_PRE_DETAILS_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
REF_NUMBER NUMBER
Yes
COMPANY_CODE VARCHAR2 (7) Yes
CPARTY_CODE VARCHAR2 (7) Yes
DEAL_NO NUMBER
Yes
CURRENCY_BUY VARCHAR2 (15) Yes
CURRENCY_SELL VARCHAR2 (15) Yes
BUY_AMOUNT NUMBER
Yes
SELL_AMOUNT NUMBER
Yes
TRANS_RATE NUMBER
Yes
BASE_RATE NUMBER
Yes
VALUE_DATE DATE
Yes
MULTIPLE_TRANS_YN VARCHAR2 (3) Yes
DEAL_DATE DATE
Yes
SETTLED_CURRENT VARCHAR2 (1) Yes
ROLL_PRE VARCHAR2 (3)
ROLL_PRE_ON DATE

PREV_DEAL_NO NUMBER

PORTFOLIO_CODE VARCHAR2 (7)
CLIENT_CODE VARCHAR2 (7)
DEALER_CODE VARCHAR2 (10)
SETTLEMENT_PARTY VARCHAR2 (7)
SETTLEMENT_PARTY_ACCT VARCHAR2 (20)
COMP_SETTLEMENT_ACCT VARCHAR2 (20)
LIMIT_CODE VARCHAR2 (7)
Query Text

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


SELECT REF_NUMBER
,      COMPANY_CODE
,      CPARTY_CODE
,      DEAL_NO
,      CURRENCY_BUY
,      CURRENCY_SELL
,      BUY_AMOUNT
,      SELL_AMOUNT
,      TRANS_RATE
,      BASE_RATE
,      VALUE_DATE
,      MULTIPLE_TRANS_YN
,      DEAL_DATE
,      SETTLED_CURRENT
,      ROLL_PRE
,      ROLL_PRE_ON
,      PREV_DEAL_NO
,      PORTFOLIO_CODE
,      CLIENT_CODE
,      DEALER_CODE
,      SETTLEMENT_PARTY
,      SETTLEMENT_PARTY_ACCT
,      COMP_SETTLEMENT_ACCT
,      LIMIT_CODE
FROM APPS.XTR_FX_ROLL_PRE_DETAILS_V;

Dependencies

[top of page]

APPS.XTR_FX_ROLL_PRE_DETAILS_V references the following:

SchemaAPPS
SynonymXTR_FX_ROLL_PRE_DETAILS

APPS.XTR_FX_ROLL_PRE_DETAILS_V is not referenced by any database object