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


VIEW: APPS.CMPRELATIONALDBITEM_V

Object Details
Object Name: CMPRELATIONALDBITEM_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)
IMPORT VARCHAR2 (1)
EXPORT VARCHAR2 (1)
REPEATING NUMBER (9)
POSITION NUMBER (9)
OWNINGRELATION NUMBER (9)
REFERENCEDITEM NUMBER (9)
ALLOWUPDATE VARCHAR2 (1)
CASESTORAGE VARCHAR2 (1)
DISPLAYNAME VARCHAR2 (40)
DISPLAYNULLVALUE VARCHAR2 (1)
EXTERNALCONTEXT VARCHAR2 (40)
DESCRIPTORTYPE VARCHAR2 (40)
EXTERNALCONTEXTTYPE VARCHAR2 (40)
EXTERNALITEMNAME VARCHAR2 (40)
HEADING VARCHAR2 (40)
PUBLILSHED VARCHAR2 (1)
ORDERCLAUSEPOSITION NUMBER (9)
PLACEMENT NUMBER (9)
ORDERDIRECTION VARCHAR2 (40)
CONTENTTYPE VARCHAR2 (40)
DATABASELENGTH NUMBER (9)
NULLABLE VARCHAR2 (1)
PRECISION NUMBER (9)
SCALE NUMBER (9)
SEQUENCE NUMBER (9)
LENGTH NUMBER (9)
DECIMALPLACES NUMBER (9)
ATTOFFSET NUMBER (9)
VARIABLE VARCHAR2 (1)
DEFAULTVALUE VARCHAR2 (2000)
TYPECODE VARCHAR2 (40)
EXPRESSION VARCHAR2 (2000)
APPSLABEL VARCHAR2 (255)
OWNINGSTRUCTURE NUMBER (9)
DOMAIN 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
,      IMPORT
,      EXPORT
,      REPEATING
,      POSITION
,      OWNINGRELATION
,      REFERENCEDITEM
,      ALLOWUPDATE
,      CASESTORAGE
,      DISPLAYNAME
,      DISPLAYNULLVALUE
,      EXTERNALCONTEXT
,      DESCRIPTORTYPE
,      EXTERNALCONTEXTTYPE
,      EXTERNALITEMNAME
,      HEADING
,      PUBLILSHED
,      ORDERCLAUSEPOSITION
,      PLACEMENT
,      ORDERDIRECTION
,      CONTENTTYPE
,      DATABASELENGTH
,      NULLABLE
,      PRECISION
,      SCALE
,      SEQUENCE
,      LENGTH
,      DECIMALPLACES
,      ATTOFFSET
,      VARIABLE
,      DEFAULTVALUE
,      TYPECODE
,      EXPRESSION
,      APPSLABEL
,      OWNINGSTRUCTURE
,      DOMAIN
FROM APPS.CMPRELATIONALDBITEM_V;

Dependencies

[top of page]

APPS.CMPRELATIONALDBITEM_V references the following:

SchemaAPPS
SynonymEDWCMPALLCLASSES

APPS.CMPRELATIONALDBITEM_V is not referenced by any database object