Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CMPWBITEMSETUSAGE_V

Object Details
Object Name: CMPWBITEMSETUSAGE_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
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)
SEQUENCE NUMBER (9)
SECURITYENABLED VARCHAR2 (1)
ITEMSET NUMBER (9)
ATTRIBUTE NUMBER (9)
VALUESET NUMBER (9)
Query Text

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
,      SEQUENCE
,      SECURITYENABLED
,      ITEMSET
,      ATTRIBUTE
,      VALUESET
FROM APPS.CMPWBITEMSETUSAGE_V;

Dependencies

[top of page]

APPS.CMPWBITEMSETUSAGE_V references the following:

SchemaAPPS
SynonymEDWCMPALLCLASSES

APPS.CMPWBITEMSETUSAGE_V is not referenced by any database object