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


TABLE: PA.PA_MAP_VALUE_SETS

Object Details
Object Name: PA_MAP_VALUE_SETS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_MAP_VALUE_SETS
Subobject Name:
Status: VALID


PA_MAP_VALUE_SETS stores the source or destination information for the mapping. Each record could be a source or a destination. The data in this table should be seeded by developers.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_MAP_VALUE_SETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVALUE_SET_ID
Columns
Name Datatype Length Mandatory Comments
VALUE_SET_ID NUMBER (15) Yes Unique identifier
VALUE_SET_CODE VARCHAR2 (30) Yes The lookup code for a value set. The meaning of the lookup code is used for rendering the source /destination column label.
OBJECT_NAME VARCHAR2 (30) Yes The name of the object which is the source or destination for the mapping. The possible objects are database tables or views.
VALUE_COLUMN_NAME VARCHAR2 (30) Yes The name for the column which contains the value for mapping
DISPLAY_COLUMN_NAME VARCHAR2 (30) Yes < Null >The name for the column which contains the value for displaying.
PK1_COLUMN_NAME VARCHAR2 (30)
The name for the column which contains a primary key of the mapping value.
PK2_COLUMN_NAME VARCHAR2 (30)
The name for the column which contains a primary key of the mapping value.
PK3_COLUMN_NAME VARCHAR2 (30)
The name for the column which contains a primary key of the mapping value.
PK4_COLUMN_NAME VARCHAR2 (30)
The name for the column which contains a primary key of the mapping value.
PK5_COLUMN_NAME VARCHAR2 (30)
The name for the column which contains a primary key of the mapping value.
SOURCE_TYPE VARCHAR2 (30) Yes The lookup code for the mapping source.
APPLICATION_ID NUMBER (15) Yes The unique identifier of the application.
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
LAST_UPDATE_LOGIN NUMBER

Standard who column
Query Text

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


SELECT VALUE_SET_ID
,      VALUE_SET_CODE
,      OBJECT_NAME
,      VALUE_COLUMN_NAME
,      DISPLAY_COLUMN_NAME
,      PK1_COLUMN_NAME
,      PK2_COLUMN_NAME
,      PK3_COLUMN_NAME
,      PK4_COLUMN_NAME
,      PK5_COLUMN_NAME
,      SOURCE_TYPE
,      APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM PA.PA_MAP_VALUE_SETS;

Dependencies

[top of page]

PA.PA_MAP_VALUE_SETS does not reference any database object

PA.PA_MAP_VALUE_SETS is referenced by following:

SchemaAPPS
SynonymPA_MAP_VALUE_SETS