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

VIEW: XTR.XTR_A_MASTER_CURRENCIES#

Object Details
Object Name: XTR_A_MASTER_CURRENCIES#
Object Type: VIEW
Owner: XTR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUDIT_DATE_STORED DATE

AUDIT_INDICATOR VARCHAR2 (1)
AUTHORISED VARCHAR2 (1) Yes
CALCULATE_HOLS_YEARS NUMBER

CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
CURRENCY VARCHAR2 (15) Yes
CURRENT_SPOT_RATE NUMBER

DIVIDE_OR_MULTIPLY VARCHAR2 (1) Yes
FX_SEQ_NO NUMBER

HCE_RATE NUMBER

IR_SEQ_NO NUMBER

LAST_TRANSACTION_CHANGED DATE

MAXIMUM_BAND NUMBER

MAX_DAYS_CONTRACT NUMBER

MINIMUM_BAND NUMBER

NAME VARCHAR2 (20) Yes
NET_FX_EXPOSURE NUMBER

RATE_DATE DATE

ROUNDING_FACTOR NUMBER

SPOT_DATE DATE

UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

USD_BASE_CURR_BID_RATE NUMBER

USD_BASE_CURR_OFFER_RATE NUMBER

USD_QUOTED_SPOT NUMBER

UTILISED_AMOUNT NUMBER

YEAR_BASIS NUMBER
Yes
IG_YEAR_BASIS VARCHAR2 (15)
Query Text

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


SELECT AUDIT_DATE_STORED
,      AUDIT_INDICATOR
,      AUTHORISED
,      CALCULATE_HOLS_YEARS
,      CREATED_BY
,      CREATED_ON
,      CURRENCY
,      CURRENT_SPOT_RATE
,      DIVIDE_OR_MULTIPLY
,      FX_SEQ_NO
,      HCE_RATE
,      IR_SEQ_NO
,      LAST_TRANSACTION_CHANGED
,      MAXIMUM_BAND
,      MAX_DAYS_CONTRACT
,      MINIMUM_BAND
,      NAME
,      NET_FX_EXPOSURE
,      RATE_DATE
,      ROUNDING_FACTOR
,      SPOT_DATE
,      UPDATED_BY
,      UPDATED_ON
,      USD_BASE_CURR_BID_RATE
,      USD_BASE_CURR_OFFER_RATE
,      USD_QUOTED_SPOT
,      UTILISED_AMOUNT
,      YEAR_BASIS
,      IG_YEAR_BASIS
FROM XTR.XTR_A_MASTER_CURRENCIES#;

Dependencies

[top of page]

XTR.XTR_A_MASTER_CURRENCIES# references the following:

SchemaXTR
TableXTR_A_MASTER_CURRENCIES
XTR.XTR_A_MASTER_CURRENCIES# is referenced by following:

SchemaAPPS
SynonymXTR_A_MASTER_CURRENCIES