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

TABLE: OSM.AS_MC_REPORTING_CURR

Object Details
Object Name: AS_MC_REPORTING_CURR
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.AS_MC_REPORTING_CURR
Subobject Name:
Status: VALID


AS_MC_REPORTING_CURRENCIES stores reporting currencies


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_MC_REPORTING_CURR_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSETUP_CURRENCY_ID
Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column
FROM_CURRENCY VARCHAR2 (15) Yes Transaction (source) currency code in currency conversion
END_DATE_ACTIVE DATE

Date which the reporting currency becomes inactive
REPORTING_CURRENCY VARCHAR2 (15) Yes Reporting (target) currency code in the currency conversion
START_DATE_ACTIVE DATE
Yes Date which the reporting currency becomes active
SETUP_CURRENCY_ID NUMBER
Yes Setup currency identifier
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
Query Text

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


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FROM_CURRENCY
,      END_DATE_ACTIVE
,      REPORTING_CURRENCY
,      START_DATE_ACTIVE
,      SETUP_CURRENCY_ID
,      SECURITY_GROUP_ID
FROM OSM.AS_MC_REPORTING_CURR;

Dependencies

[top of page]

OSM.AS_MC_REPORTING_CURR does not reference any database object

OSM.AS_MC_REPORTING_CURR is referenced by following:

SchemaOSM
ViewAS_MC_REPORTING_CURR#