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

TABLE: AMS.AMS_DM_INTER_SOURCE_STG

Object Details
Object Name: AMS_DM_INTER_SOURCE_STG
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_DM_INTER_SOURCE_STG
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_DM_INTER_SOURCE_STG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTY_ID
AMS_DM_INTER_SOURCE_STG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnARC_OBJECT_USED_BY
ColumnOBJECT_USED_BY_ID
Columns
Name Datatype Length Mandatory Comments
ARC_OBJECT_USED_BY VARCHAR2 (30)
Qualifier of the object being processed.
OBJECT_USED_BY_ID NUMBER

Identifier of the object being processed.
PARTY_ID NUMBER

Unique identifier of the data source object.
ENABLED_FLAG VARCHAR2 (1)
Indicates whether the record is enabled as one of the records to go into the source table for the data mining engine.
RANDOM_GENERATED_NUM NUMBER

Holds the randomly generated number used in the processing algorithm.
TARGET_VALUE VARCHAR2 (30)
The derived target value used in model building.
Query Text

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


SELECT ARC_OBJECT_USED_BY
,      OBJECT_USED_BY_ID
,      PARTY_ID
,      ENABLED_FLAG
,      RANDOM_GENERATED_NUM
,      TARGET_VALUE
FROM AMS.AMS_DM_INTER_SOURCE_STG;

Dependencies

[top of page]

AMS.AMS_DM_INTER_SOURCE_STG does not reference any database object

AMS.AMS_DM_INTER_SOURCE_STG is referenced by following:

SchemaAPPS
SynonymAMS_DM_INTER_SOURCE_STG