[Home] [Help] [Dependency Information]
Object Name: | PA_VALUE_MAPS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALUE_MAP_ID | NUMBER | (15) | Yes | |
VALUE_MAP_DEF_ID | NUMBER | (15) | Yes | |
SOURCE_VALUE | VARCHAR2 | (240) | Yes | |
DEST_VALUE | VARCHAR2 | (240) | Yes | |
SOURCE_VALUE_PK1 | VARCHAR2 | (240) | ||
SOURCE_VALUE_PK2 | VARCHAR2 | (240) | ||
SOURCE_VALUE_PK3 | VARCHAR2 | (240) | ||
SOURCE_VALUE_PK4 | VARCHAR2 | (240) | ||
SOURCE_VALUE_PK5 | VARCHAR2 | (240) | ||
DEST_VALUE_PK1 | VARCHAR2 | (240) | ||
DEST_VALUE_PK2 | VARCHAR2 | (240) | ||
DEST_VALUE_PK3 | VARCHAR2 | (240) | ||
DEST_VALUE_PK4 | VARCHAR2 | (240) | ||
DEST_VALUE_PK5 | VARCHAR2 | (240) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT VALUE_MAP_ID
, VALUE_MAP_DEF_ID
, SOURCE_VALUE
, DEST_VALUE
, SOURCE_VALUE_PK1
, SOURCE_VALUE_PK2
, SOURCE_VALUE_PK3
, SOURCE_VALUE_PK4
, SOURCE_VALUE_PK5
, DEST_VALUE_PK1
, DEST_VALUE_PK2
, DEST_VALUE_PK3
, DEST_VALUE_PK4
, DEST_VALUE_PK5
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM PA.PA_VALUE_MAPS#;
|
|
|