[Home] [Help] [Dependency Information]
Object Name: | CZ_EXV_APC_PROPERTIES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR_GROUP_ID | NUMBER | (10) | Yes | |
ITEM_CATALOG_GROUP_ID | VARCHAR2 | (150) | ||
ATTR_ID | NUMBER | (15) | ||
APPLICATION_ID | NUMBER | (10) | Yes | |
ATTR_GROUP_TYPE | VARCHAR2 | (40) | Yes | |
ATTR_GROUP_NAME | VARCHAR2 | (30) | Yes | |
ATTR_NAME | VARCHAR2 | (30) | Yes | |
ATTR_DISPLAY_NAME | VARCHAR2 | (80) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
DATABASE_COLUMN | VARCHAR2 | (30) | Yes | |
DATA_TYPE_CODE | VARCHAR2 | (30) | ||
SEQUENCE | NUMBER | (3) | Yes | |
UNIQUE_KEY_FLAG | VARCHAR2 | (1) | ||
DEFAULT_VALUE | VARCHAR2 | (2000) | ||
INFO_1 | VARCHAR2 | (2048) | ||
UOM_CLASS | VARCHAR2 | (10) | ||
CONTROL_LEVEL | NUMBER | (15) | ||
VALUE_SET_ID | NUMBER | (10) | ||
VALUE_SET_NAME | VARCHAR2 | (60) | ||
FORMAT_CODE | VARCHAR2 | (1) | ||
MAXIMUM_SIZE | NUMBER | (3) | ||
VALIDATION_CODE | VARCHAR2 | (1) | ||
LONGLIST_FLAG | VARCHAR2 | (1) | ||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
ENABLED_MEANING | VARCHAR2 | (80) | Yes | |
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | |
REQUIRED_MEANING | VARCHAR2 | (80) | Yes | |
SEARCH_FLAG | VARCHAR2 | (1) | ||
SEARCH_MEANING | VARCHAR2 | (80) | ||
DISPLAY_CODE | VARCHAR2 | (1) | Yes | |
DISPLAY_MEANING | VARCHAR2 | (80) | Yes | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | ||
VIEW_IN_HIERARCHY_CODE | VARCHAR2 | (30) | ||
EDIT_IN_HIERARCHY_CODE | VARCHAR2 | (30) | ||
CUSTOMIZATION_LEVEL | VARCHAR2 | (1) | ||
MINIMUM_VALUE | VARCHAR2 | (150) | ||
MAXIMUM_VALUE | VARCHAR2 | (150) | ||
VALIDATION_CODE_VS | VARCHAR2 | (1) | ||
READ_ONLY_FLAG | VARCHAR2 | (1) | ||
READ_ONLY_MEANING | VARCHAR2 | (80) |
Cut, paste (and edit) the following text to query this object:
SELECT ATTR_GROUP_ID
, ITEM_CATALOG_GROUP_ID
, ATTR_ID
, APPLICATION_ID
, ATTR_GROUP_TYPE
, ATTR_GROUP_NAME
, ATTR_NAME
, ATTR_DISPLAY_NAME
, DESCRIPTION
, DATABASE_COLUMN
, DATA_TYPE_CODE
, SEQUENCE
, UNIQUE_KEY_FLAG
, DEFAULT_VALUE
, INFO_1
, UOM_CLASS
, CONTROL_LEVEL
, VALUE_SET_ID
, VALUE_SET_NAME
, FORMAT_CODE
, MAXIMUM_SIZE
, VALIDATION_CODE
, LONGLIST_FLAG
, ENABLED_FLAG
, ENABLED_MEANING
, REQUIRED_FLAG
, REQUIRED_MEANING
, SEARCH_FLAG
, SEARCH_MEANING
, DISPLAY_CODE
, DISPLAY_MEANING
, ATTRIBUTE_CODE
, VIEW_IN_HIERARCHY_CODE
, EDIT_IN_HIERARCHY_CODE
, CUSTOMIZATION_LEVEL
, MINIMUM_VALUE
, MAXIMUM_VALUE
, VALIDATION_CODE_VS
, READ_ONLY_FLAG
, READ_ONLY_MEANING
FROM APPS.CZ_EXV_APC_PROPERTIES;
|
|
|