eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CMPFUNCTIONCATEGORY_V

Object Details

Object Name:	CMPFUNCTIONCATEGORY_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)
CATEGORYTYPE	VARCHAR2	(40)
PACKAGE	VARCHAR2	(1)
INSTALLEDMODULE	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
,      CATEGORYTYPE
,      PACKAGE
,      INSTALLEDMODULE
FROM APPS.CMPFUNCTIONCATEGORY_V;

Dependencies

[top of page]

APPS.CMPFUNCTIONCATEGORY_V references the following:

APPS: EDWCMPALLCLASSES

APPS.CMPFUNCTIONCATEGORY_V is not referenced by any database object