[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CMPWBITEMUSAGE_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) | ||
| FREEZE | VARCHAR2 | (1) | ||
| TEMPLATE | NUMBER | (9) | ||
| SEQUENCE | NUMBER | (9) | ||
| AGGREGATEFUNCTION | VARCHAR2 | (40) | ||
| ORDERBY | NUMBER | (9) | ||
| ASCENDING | VARCHAR2 | (1) | ||
| SELF | VARCHAR2 | (1) | ||
| SELFOPERATION | VARCHAR2 | (40) | ||
| ERRORMESSAGE | VARCHAR2 | (40) | ||
| ALIAS | VARCHAR2 | (40) | ||
| EXPRESSION | VARCHAR2 | (2000) | ||
| CONSTANT | VARCHAR2 | (1) | ||
| TRANSFORMSEQUENCE | NUMBER | (9) | ||
| VISIBLE | VARCHAR2 | (1) | ||
| ISDISTINCT | VARCHAR2 | (1) | ||
| RELATEDTRANSFORMVISIBLE | VARCHAR2 | (1) | ||
| CMPWBRELATIONUSAGE | NUMBER | (9) | ||
| CMPITEM | 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
, FREEZE
, TEMPLATE
, SEQUENCE
, AGGREGATEFUNCTION
, ORDERBY
, ASCENDING
, SELF
, SELFOPERATION
, ERRORMESSAGE
, ALIAS
, EXPRESSION
, CONSTANT
, TRANSFORMSEQUENCE
, VISIBLE
, ISDISTINCT
, RELATEDTRANSFORMVISIBLE
, CMPWBRELATIONUSAGE
, CMPITEM
FROM APPS.CMPWBITEMUSAGE_V;
APPS
EDWCMPALLCLASSES
APPS
EDW_PVT_MAP_COLUMNS_MD_V
|
|
|
|