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

TABLE: AMS.AMS_DM_PERINT_STG

Object Details
Object Name: AMS_DM_PERINT_STG
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_DM_PERINT_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_PERINT_STG_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes Party identifier.
INTEREST_ART_FLAG VARCHAR2 (1)
Interest in art indicator.
INTEREST_BOOKS_FLAG VARCHAR2 (1)
Interest in books indicator.
INTEREST_MOVIES_FLAG VARCHAR2 (1)
Interest in movies indicator.
INTEREST_MUSIC_FLAG VARCHAR2 (1)
Interest in music indicator.
INTEREST_THEATER_FLAG VARCHAR2 (1)
Interest in theater indicator.
INTEREST_TRAVEL_FLAG VARCHAR2 (1)
Interest in travel indicator.
INTEREST_DRINK_FLAG VARCHAR2 (1)
Interest in drinking indicator.
INTEREST_SMOKE_FLAG VARCHAR2 (1)
Interest in smoking indicator.
INTEREST_OTHER_FLAG VARCHAR2 (1)
Other interests indicator.
Query Text

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


SELECT PARTY_ID
,      INTEREST_ART_FLAG
,      INTEREST_BOOKS_FLAG
,      INTEREST_MOVIES_FLAG
,      INTEREST_MUSIC_FLAG
,      INTEREST_THEATER_FLAG
,      INTEREST_TRAVEL_FLAG
,      INTEREST_DRINK_FLAG
,      INTEREST_SMOKE_FLAG
,      INTEREST_OTHER_FLAG
FROM AMS.AMS_DM_PERINT_STG;

Dependencies

[top of page]

AMS.AMS_DM_PERINT_STG does not reference any database object

AMS.AMS_DM_PERINT_STG is referenced by following:

SchemaAMS
ViewAMS_DM_PERINT_STG#