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


VIEW: APPS.CMPRELATIONMAPPING_V

Object Details
Object Name: CMPRELATIONMAPPING_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)
ISDIMENSION VARCHAR2 (1)
DIMENSIONTYPE VARCHAR2 (40)
ISDISTINCT VARCHAR2 (1)
PUBLISHED VARCHAR2 (1)
EXTERNALRELATIONNAME VARCHAR2 (40)
EXTERNALRELATIONOWNER VARCHAR2 (40)
EXTERNALDATABASELINK VARCHAR2 (40)
CBOHINT VARCHAR2 (40)
ABSTRACTPARAMETER VARCHAR2 (1)
PREFIX VARCHAR2 (40)
INSTALLEDMODULE NUMBER (9)
SEQUENCENUMBER NUMBER (9)
MAPPINGTYPECODE VARCHAR2 (40)
HINT VARCHAR2 (2000)
SOURCEALIAS VARCHAR2 (40)
IMPLEMENTIONTYPE VARCHAR2 (40)
CREATEASSELECT VARCHAR2 (1)
CURSORBASED VARCHAR2 (1)
PACKAGELOCATION VARCHAR2 (40)
SOURCETOWAREHOUSEDBLINK VARCHAR2 (40)
WAREHOUSETOSOURCEDBLINK VARCHAR2 (40)
LOOPITERATIONS NUMBER (9)
HINTALLOWED VARCHAR2 (1)
FILTERALLOWED VARCHAR2 (1)
ORDERBYALLOWED VARCHAR2 (1)
SECONDARYSRCSALLOWED VARCHAR2 (1)
AGGREGATIONSALLOWED VARCHAR2 (1)
TARGETMAPTYPEALLOWED VARCHAR2 (1)
PRIORITY NUMBER (9)
GLOBALVARX NUMBER (9)
GLOBALVARY NUMBER (9)
LOCALVARX NUMBER (9)
LOCALVARY NUMBER (9)
PARAMX NUMBER (9)
PARAMY NUMBER (9)
SHOWALL VARCHAR2 (1)
GLOBALVAREXPANDED VARCHAR2 (1)
LOCALVAREXPANDED VARCHAR2 (1)
PARAMETERVAREXPANDED VARCHAR2 (1)
FILTEREDITED VARCHAR2 (1)
PARENTMODEL NUMBER (9)
MAPTYPE NUMBER (9)
SOURCEDATAENTITY NUMBER (9)
TARGETDATAENTITY NUMBER (9)
FOREIGNKEY NUMBER (9)
DRIVERRELATIONMAPPING 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
,      ISDIMENSION
,      DIMENSIONTYPE
,      ISDISTINCT
,      PUBLISHED
,      EXTERNALRELATIONNAME
,      EXTERNALRELATIONOWNER
,      EXTERNALDATABASELINK
,      CBOHINT
,      ABSTRACTPARAMETER
,      PREFIX
,      INSTALLEDMODULE
,      SEQUENCENUMBER
,      MAPPINGTYPECODE
,      HINT
,      SOURCEALIAS
,      IMPLEMENTIONTYPE
,      CREATEASSELECT
,      CURSORBASED
,      PACKAGELOCATION
,      SOURCETOWAREHOUSEDBLINK
,      WAREHOUSETOSOURCEDBLINK
,      LOOPITERATIONS
,      HINTALLOWED
,      FILTERALLOWED
,      ORDERBYALLOWED
,      SECONDARYSRCSALLOWED
,      AGGREGATIONSALLOWED
,      TARGETMAPTYPEALLOWED
,      PRIORITY
,      GLOBALVARX
,      GLOBALVARY
,      LOCALVARX
,      LOCALVARY
,      PARAMX
,      PARAMY
,      SHOWALL
,      GLOBALVAREXPANDED
,      LOCALVAREXPANDED
,      PARAMETERVAREXPANDED
,      FILTEREDITED
,      PARENTMODEL
,      MAPTYPE
,      SOURCEDATAENTITY
,      TARGETDATAENTITY
,      FOREIGNKEY
,      DRIVERRELATIONMAPPING
FROM APPS.CMPRELATIONMAPPING_V;

Dependencies

[top of page]

APPS.CMPRELATIONMAPPING_V references the following:

SchemaAPPS
SynonymEDWCMPALLCLASSES

APPS.CMPRELATIONMAPPING_V is not referenced by any database object