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

VIEW: APPS.CMPLEVELRELATIONSHIP_V

Object Details
Object Name: CMPLEVELRELATIONSHIP_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)
VISIBLE VARCHAR2 (1)
EXCLUDENULLPARENTS VARCHAR2 (1)
HIERARCHY NUMBER (9)
PARENTLEVEL NUMBER (9)
CHILDLEVEL NUMBER (9)
M_CMPITEM 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
,      VISIBLE
,      EXCLUDENULLPARENTS
,      HIERARCHY
,      PARENTLEVEL
,      CHILDLEVEL
,      M_CMPITEM
FROM APPS.CMPLEVELRELATIONSHIP_V;

Dependencies

[top of page]

APPS.CMPLEVELRELATIONSHIP_V references the following:

SchemaAPPS
SynonymEDWCMPALLCLASSES

APPS.CMPLEVELRELATIONSHIP_V is not referenced by any database object