[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CMPITEMHIERARCHY_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) | ||
| 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) | ||
| EFFDT | VARCHAR2 | (40) | ||
| TREESTRCTID | VARCHAR2 | (40) | ||
| SETID | VARCHAR2 | (40) | ||
| EFFSTATUS | VARCHAR2 | (40) | ||
| ALLVALUES | VARCHAR2 | (40) | ||
| USELEVELS | VARCHAR2 | (1) | ||
| VALIDTREE | VARCHAR2 | (40) | ||
| LEVELCOUNT | VARCHAR2 | (40) | ||
| NODECOUNT | VARCHAR2 | (40) | ||
| LEAFCOUNT | VARCHAR2 | (40) | ||
| TREEHASRANGES | VARCHAR2 | (40) | ||
| DUPLICATELEAF | VARCHAR2 | (40) | ||
| TREECATEGORY | VARCHAR2 | (40) | ||
| STARTDATE | DATE | |||
| ENDDATE | DATE | |||
| OWNDIMENSION | NUMBER | (9) | ||
| ITEMSET | 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
, ISDIMENSION
, DIMENSIONTYPE
, ISDISTINCT
, PUBLISHED
, EXTERNALRELATIONNAME
, EXTERNALRELATIONOWNER
, EXTERNALDATABASELINK
, CBOHINT
, ABSTRACTPARAMETER
, PREFIX
, INSTALLEDMODULE
, EFFDT
, TREESTRCTID
, SETID
, EFFSTATUS
, ALLVALUES
, USELEVELS
, VALIDTREE
, LEVELCOUNT
, NODECOUNT
, LEAFCOUNT
, TREEHASRANGES
, DUPLICATELEAF
, TREECATEGORY
, STARTDATE
, ENDDATE
, OWNDIMENSION
, ITEMSET
FROM APPS.CMPITEMHIERARCHY_V;
APPS
EDWCMPALLCLASSES
APPS.CMPITEMHIERARCHY_V is not referenced by any database object
|
|
|
|