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_BUS_DOC_EVENTS_V

Object Details

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

View Type

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

View based on OKC_BUS_DOC_EVENTS_B and OKC_BUS_DOC_EVENTS_TL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Autogenerated id
BUS_DOC_EVENT_ID	NUMBER		Yes	Unique Identifier for a Business Document Event. Also the Primary key for the underlying base table, OKC_BUS_DOC_EVENTS_B
BUSINESS_EVENT_CODE	VARCHAR2	(30)	Yes	Textual Identifier for the given Business Document Event. Also, a Foreign Key to LOOKUP_CODE in FND_LOOKUPS for the Lookup Type OKC_BUS_DOC_EVENT
BUS_DOC_TYPE	VARCHAR2	(30)	Yes	Business Document Type for the given Business Document Event. Also, a foreign key to BUSINESS_DOCUMENT_TYPE in OKC_BUS_DOC_TYPES_B
BEFORE_AFTER	VARCHAR2	(1)	Yes	Code Value to signify whether the given Deliverable is due Before or After the specified Business Document Event. Also, a foreign key to LOOKUP_CODE in FND_LOOKUPS for the Lookup Type OKC_DEL_BEF_AFT
START_END_QUALIFIER	VARCHAR2	(30)	Yes	Code Value to identify whether, for a given Deliverable, the specified Business Document Event can be used as the starting event or ending event or both. Also, a foreign key to LOOKUP_CODE in FND_LOOKUPS for the Lookup Type OKC_REPEAT_UNTIL_EVENT
EVENT_NAME	VARCHAR2	(80)	Yes	Translatable Meaning for the given Business Document Event
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
,      BUS_DOC_EVENT_ID
,      BUSINESS_EVENT_CODE
,      BUS_DOC_TYPE
,      BEFORE_AFTER
,      START_END_QUALIFIER
,      EVENT_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM APPS.OKC_BUS_DOC_EVENTS_V;

Dependencies

[top of page]

APPS.OKC_BUS_DOC_EVENTS_V references the following:

APPS: OKC_BUS_DOC_EVENTS_B; OKC_BUS_DOC_EVENTS_TL

APPS.OKC_BUS_DOC_EVENTS_V is referenced by following:

APPS: OKC_DELIVERABLE_PROCESS_PVT - show dependent code; OKC_IMP_TERMS_TEMPLATES_PVT - show dependent code; OKC_TERMS_MIGRATE_GRP - show dependent code