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.OKC_DELIVERABLE_TYPES_VL

Object Details

Object Name:	OKC_DELIVERABLE_TYPES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKC.OKC_DELIVERABLE_TYPES_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View to retrieve all the deliverable types along with their name, description based on the user`s session language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		The address of the row in the database
DELIVERABLE_TYPE_CODE	VARCHAR2	(30)	Yes	Code to uniquely identify the deliverable type.
NAME	VARCHAR2	(150)	Yes	Name of the deliverable type.
DESCRIPTION	VARCHAR2	(2000)		Description of deliverable type..
INTERNAL_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the deliverable type is INTERNAL or not. Valid values are Y and N. A deliverable that is a not internal is deemed to be Contractual in nature and is printed as part of the contract and fullfiled as part of the obligations of either party on the contract.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      DELIVERABLE_TYPE_CODE
,      NAME
,      DESCRIPTION
,      INTERNAL_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM APPS.OKC_DELIVERABLE_TYPES_VL;

Dependencies

[top of page]

APPS.OKC_DELIVERABLE_TYPES_VL references the following:

APPS: OKC_DELIVERABLE_TYPES_B; OKC_DELIVERABLE_TYPES_TL

APPS.OKC_DELIVERABLE_TYPES_VL is not referenced by any database object