[Home] [Help] [Dependency Information]
Object Name: | CZ_CREATERULEOBJECT_LKV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_CREATERULEOBJECT_LKV |
Subobject Name: | |
Status: | VALID |
CZ_CREATERULEOBJECT_LKV lists the different (detailed) rule types the user can create
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_NAME | VARCHAR2 | (50) | Yes | |
ENCLOSING_TYPE | NUMBER | Yes | ||
DATA_VALUE | VARCHAR2 | (255) | Yes | |
DETAILED_RULE_TYPE | NUMBER | Yes | ||
VALUE_SEQ | NUMBER | |||
NULL_VALUE_FLAG | VARCHAR2 | (1) | ||
VALUE_LABEL | VARCHAR2 | (255) | ||
VALUE_DESCRIPTION | VARCHAR2 | (4000) | ||
VALUE_NOTES | CLOB | (4000) | ||
NUMERIC_ID_VALUE | NUMBER | |||
P_MODEL_ID | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_NAME
, ENCLOSING_TYPE
, DATA_VALUE
, DETAILED_RULE_TYPE
, VALUE_SEQ
, NULL_VALUE_FLAG
, VALUE_LABEL
, VALUE_DESCRIPTION
, VALUE_NOTES
, NUMERIC_ID_VALUE
, P_MODEL_ID
FROM APPS.CZ_CREATERULEOBJECT_LKV;
|
|
|