[Home] [Help] [Dependency Information]
Object Name: | PV_ENTITY_ATTRS# |
---|---|
Object Type: | VIEW |
Owner: | PV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ENTITY_ATTR_ID | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
ATTRIBUTE_ID | NUMBER | (15) | Yes | |
ENTITY | VARCHAR2 | (30) | Yes | |
SRC_TABLE_NAME | VARCHAR2 | (50) | ||
SRC_PKCOL_NAME | VARCHAR2 | (100) | ||
SQL_TEXT | VARCHAR2 | (2000) | ||
ATTR_DATA_TYPE | VARCHAR2 | (30) | ||
LOV_STRING | VARCHAR2 | (2000) | ||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
ITEM_STYLE | VARCHAR2 | (30) | ||
SELECTION_TYPE | VARCHAR2 | (1) | ||
DISPLAY_FLAG | VARCHAR2 | (1) | Yes | |
RANK | NUMBER | (3) | ||
AUTO_ASSIGN_FLAG | VARCHAR2 | (1) | ||
SECURITY_GROUP_ID | NUMBER | (15) | ||
LOCATOR_FLAG | VARCHAR2 | (1) | ||
ENTITY_TYPE | VARCHAR2 | (30) | ||
REQUIRE_VALIDATION_FLAG | VARCHAR2 | (1) | ||
EXTERNAL_UPDATE_TEXT | VARCHAR2 | (2000) | ||
BATCH_SQL_TEXT | VARCHAR2 | (2000) | ||
REFRESH_FREQUENCY | NUMBER | |||
REFRESH_FREQUENCY_UOM | VARCHAR2 | (20) | ||
LAST_REFRESH_DATE | DATE | |||
DISPLAY_EXTERNAL_VALUE_FLAG | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ENTITY_ATTR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_ID
, ENTITY
, SRC_TABLE_NAME
, SRC_PKCOL_NAME
, SQL_TEXT
, ATTR_DATA_TYPE
, LOV_STRING
, ENABLED_FLAG
, ITEM_STYLE
, SELECTION_TYPE
, DISPLAY_FLAG
, RANK
, AUTO_ASSIGN_FLAG
, SECURITY_GROUP_ID
, LOCATOR_FLAG
, ENTITY_TYPE
, REQUIRE_VALIDATION_FLAG
, EXTERNAL_UPDATE_TEXT
, BATCH_SQL_TEXT
, REFRESH_FREQUENCY
, REFRESH_FREQUENCY_UOM
, LAST_REFRESH_DATE
, DISPLAY_EXTERNAL_VALUE_FLAG
, ZD_EDITION_NAME
FROM PV.PV_ENTITY_ATTRS#;
|
|
|