[Home] [Help] [Dependency Information]
Object Name: | IEO_CP_SVC_FIELDS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | IEO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_SVC_FIELD_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
FIELD_NAME | VARCHAR2 | (30) | Yes | |
ORG_ID | NUMBER | (15) | Yes | |
LIST_SRV_NAME | VARCHAR2 | (30) | Yes | |
SREF_TYPE | VARCHAR2 | (5) | Yes | |
FIELD_WIDTH | NUMBER | (9) | ||
FIELD_TYPE | NUMBER | (9) | ||
JUSTIFY_FLG | NUMBER | (9) | ||
SRV_FIELD_NUM | NUMBER | (9) | ||
OFFSET | NUMBER | (9) | ||
SORT_DIRECTION | VARCHAR2 | (5) | ||
TEL_FLAG | VARCHAR2 | (5) | ||
CALL_MAP | VARCHAR2 | (100) | ||
SECURITY_GROUP_ID | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CP_SVC_FIELD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FIELD_NAME
, ORG_ID
, LIST_SRV_NAME
, SREF_TYPE
, FIELD_WIDTH
, FIELD_TYPE
, JUSTIFY_FLG
, SRV_FIELD_NUM
, OFFSET
, SORT_DIRECTION
, TEL_FLAG
, CALL_MAP
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEO.IEO_CP_SVC_FIELDS_ALL#;
|
|
|