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

TABLE: OSM.AS_MC_TYPE_MAPPINGS

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


AS_MC_TYPE_MAPPINGS records the mappings from a period type of a period set(calendar) to a conversion type.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_MC_TYPE_MAPPINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnPERIOD_SET_NAME
ColumnPERIOD_TYPE
Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15) Yes Calendar.
PERIOD_TYPE VARCHAR2 (15) Yes Period types mapped from.
CONVERSION_TYPE VARCHAR2 (30) Yes Daily conversion types to.
DESCRIPTION VARCHAR2 (80)
Description.
UPDATEABLE_FLAG VARCHAR2 (1)
If daily rates are updateable from OSM for this mapping.
DELETEABLE_FLAG VARCHAR2 (1)
If daily rates are deleteable from OSM for this mapping.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes WHO columns.
CREATION_DATE DATE
Yes WHO columns.
CREATED_BY NUMBER
Yes WHO columns.
LAST_UPDATE_LOGIN NUMBER
Yes WHO columns.
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 PERIOD_SET_NAME
,      PERIOD_TYPE
,      CONVERSION_TYPE
,      DESCRIPTION
,      UPDATEABLE_FLAG
,      DELETEABLE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM OSM.AS_MC_TYPE_MAPPINGS;

Dependencies

[top of page]

OSM.AS_MC_TYPE_MAPPINGS does not reference any database object

OSM.AS_MC_TYPE_MAPPINGS is referenced by following:

SchemaOSM
ViewAS_MC_TYPE_MAPPINGS#