[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CMPDATATYPE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DELETIONPARENT | NUMBER | (22) | ||
| CLASSNAME | VARCHAR2 | (255) | Yes | |
| CREATIONTIMESTAMP | DATE | |||
| UPDATETIMESTAMP | DATE | |||
| NOTE | VARCHAR2 | (2000) | ||
| NUMBEROFTIMESMODIIED | NUMBER | (9) | ||
| VERSION | VARCHAR2 | (40) | ||
| ELEMENTID | NUMBER | (9) | Yes | |
| NAME | VARCHAR2 | (255) | ||
| LONGNAME | VARCHAR2 | (2000) | ||
| DESCRIPTION | VARCHAR2 | (2000) | ||
| EDITABLE | VARCHAR2 | (1) | ||
| GENERATED | VARCHAR2 | (1) | ||
| SEEDED | VARCHAR2 | (1) | ||
| COMPLETED | VARCHAR2 | (1) | ||
| FROZEN | VARCHAR2 | (1) | ||
| DISABLED | VARCHAR2 | (1) | ||
| IMPORTED | VARCHAR2 | (1) | ||
| READABLE | VARCHAR2 | (1) | ||
| DELETABLE | VARCHAR2 | (1) | ||
| CUSTOMEREDITABLE | VARCHAR2 | (1) | ||
| NAMESPACENAME | VARCHAR2 | (255) | ||
| VALIDATIONRESULT | NUMBER | (9) | ||
| OWNINGINTERSECTION | NUMBER | (9) | ||
| CREATEDBY | NUMBER | (9) | ||
| UPDATEDBY | NUMBER | (9) | ||
| XCOORDINATE | NUMBER | (9) | ||
| YCOORDINATE | NUMBER | (9) | ||
| LIBRARYDISABLED | VARCHAR2 | (1) | ||
| PROJECT | NUMBER | (9) | ||
| SOFTWAREMODVERSION | NUMBER | (9) | ||
| DATATYPE | VARCHAR2 | (40) | ||
| PREDEFINED | VARCHAR2 | (1) | ||
| LENGTHALLOWED | VARCHAR2 | (1) | ||
| PRECISIONALLOWED | VARCHAR2 | (1) | ||
| SCALEALLOWED | VARCHAR2 | (1) | ||
| MINIMUMLENGTH | NUMBER | (9) | ||
| MAXIMUMLENGTH | NUMBER | (9) | ||
| DEFAULTLENGTH | NUMBER | (9) | ||
| MINIMUMPRECISION | NUMBER | (9) | ||
| MAXIMUMPRECISION | NUMBER | (9) | ||
| DEFAULTPRECISION | NUMBER | (9) | ||
| MINIMUMSCALE | NUMBER | (9) | ||
| MAXIMUMSCALE | NUMBER | (9) | ||
| DEFAULTSCALE | NUMBER | (9) | ||
| ICON | VARCHAR2 | (255) | ||
| MEMBERSHIPLIST | NUMBER | (9) | ||
| OWNINGLANGUAGE | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT DELETIONPARENT
, CLASSNAME
, CREATIONTIMESTAMP
, UPDATETIMESTAMP
, NOTE
, NUMBEROFTIMESMODIIED
, VERSION
, ELEMENTID
, NAME
, LONGNAME
, DESCRIPTION
, EDITABLE
, GENERATED
, SEEDED
, COMPLETED
, FROZEN
, DISABLED
, IMPORTED
, READABLE
, DELETABLE
, CUSTOMEREDITABLE
, NAMESPACENAME
, VALIDATIONRESULT
, OWNINGINTERSECTION
, CREATEDBY
, UPDATEDBY
, XCOORDINATE
, YCOORDINATE
, LIBRARYDISABLED
, PROJECT
, SOFTWAREMODVERSION
, DATATYPE
, PREDEFINED
, LENGTHALLOWED
, PRECISIONALLOWED
, SCALEALLOWED
, MINIMUMLENGTH
, MAXIMUMLENGTH
, DEFAULTLENGTH
, MINIMUMPRECISION
, MAXIMUMPRECISION
, DEFAULTPRECISION
, MINIMUMSCALE
, MAXIMUMSCALE
, DEFAULTSCALE
, ICON
, MEMBERSHIPLIST
, OWNINGLANGUAGE
FROM APPS.CMPDATATYPE_V;
APPS
EDWCMPALLCLASSES
APPS.CMPDATATYPE_V is not referenced by any database object
|
|
|
|