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

VIEW: APPS.CMPWBRELATIONUSAGE_V

Object Details
Object Name: CMPWBRELATIONUSAGE_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)
XCOORDINATE NUMBER (9)
YCOORDINATE NUMBER (9)
LIBRARYDISABLED VARCHAR2 (1)
PROJECT NUMBER (9)
SOFTWAREMODVERSION NUMBER (9)
FREEZE VARCHAR2 (1)
TEMPLATE NUMBER (9)
SOURCE VARCHAR2 (1)
OUTERJOIN VARCHAR2 (1)
IFDELETECONDITION VARCHAR2 (40)
ALIAS VARCHAR2 (40)
DMLTYPE VARCHAR2 (40)
IFINSERTCONDITION VARCHAR2 (40)
IFUPDATECONDITION VARCHAR2 (40)
DELETEWHERE VARCHAR2 (40)
UPDATEWHERE VARCHAR2 (40)
LOOPCONDITION VARCHAR2 (40)
DISPLAYALL VARCHAR2 (1)
MAPPABLEEXPANDED VARCHAR2 (1)
CURRENTNAMEDATTRIBUTESET NUMBER (9)
CMPRELATION NUMBER (9)
CMPRELATIONMAPPING 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
,      XCOORDINATE
,      YCOORDINATE
,      LIBRARYDISABLED
,      PROJECT
,      SOFTWAREMODVERSION
,      FREEZE
,      TEMPLATE
,      SOURCE
,      OUTERJOIN
,      IFDELETECONDITION
,      ALIAS
,      DMLTYPE
,      IFINSERTCONDITION
,      IFUPDATECONDITION
,      DELETEWHERE
,      UPDATEWHERE
,      LOOPCONDITION
,      DISPLAYALL
,      MAPPABLEEXPANDED
,      CURRENTNAMEDATTRIBUTESET
,      CMPRELATION
,      CMPRELATIONMAPPING
FROM APPS.CMPWBRELATIONUSAGE_V;

Dependencies

[top of page]

APPS.CMPWBRELATIONUSAGE_V references the following:

SchemaAPPS
SynonymEDWCMPALLCLASSES
APPS.CMPWBRELATIONUSAGE_V is referenced by following:

SchemaAPPS
ViewEDW_PVT_MAP_COLUMNS_MD_V
ViewEDW_PVT_MAP_KEY_USAGES_MD_V