[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CMPFOREIGNKEY_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| 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) | ||
| APPSLABEL | VARCHAR2 | (255) | ||
| MANDITORY | VARCHAR2 | (1) | ||
| ONETOONE | VARCHAR2 | (1) | ||
| UNIQUEKEY | NUMBER | (9) | ||
| RELATIONMAPPING | NUMBER | (9) |
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
, APPSLABEL
, MANDITORY
, ONETOONE
, UNIQUEKEY
, RELATIONMAPPING
FROM APPS.CMPFOREIGNKEY_V;
APPS
EDWCMPALLCLASSES
APPS
EDW_PVT_MAP_KEY_USAGES_MD_V
|
|
|
|