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_K_HISTORY_V

Object Details

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

View Type

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

Contracts status history view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
ID	NUMBER		Yes	Primary Key for the contract status history table
CHR_ID	NUMBER		Yes	Contract Header Id
CLE_ID	NUMBER			Contract Line Id
CONTRACT_VERSION	VARCHAR2	(24)	Yes	Contract header version number when the status changed
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
OPN_CODE	VARCHAR2	(30)	Yes	Operation code that caused the status change
STS_CODE_FROM	VARCHAR2	(30)		Contract status before change
STS_CODE_TO	VARCHAR2	(30)		Contract status after change
REASON_CODE	VARCHAR2	(30)		Reason for contract status change
TRN_CODE	VARCHAR2	(30)		Reason for terminating the contract
MANUAL_YN	VARCHAR2	(3)	Yes	Indicates whether the contract status change is manual or automatic. Any change from the status change form will be consider manual status change.
COMMENTS	VARCHAR2	(4000)		User entered comment.
CREATED_BY	NUMBER	(15)	Yes	FND user id who created the contract
CREATION_DATE	DATE		Yes	Creation date
LAST_UPDATED_BY	NUMBER	(15)	Yes	FND user id who updated the record last
LAST_UPDATE_DATE	DATE		Yes	Last update date
LAST_UPDATE_LOGIN	NUMBER	(15)		Login for the last updated user
PROGRAM_APPLICATION_ID	NUMBER			Standard concurrent column
PROGRAM_ID	NUMBER			Standard concurrent column
PROGRAM_UPDATE_DATE	DATE			Standard concurrent column
REQUEST_ID	NUMBER			Standard concurrent column

Query Text

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


SELECT ROW_ID
,      ID
,      CHR_ID
,      CLE_ID
,      CONTRACT_VERSION
,      OBJECT_VERSION_NUMBER
,      OPN_CODE
,      STS_CODE_FROM
,      STS_CODE_TO
,      REASON_CODE
,      TRN_CODE
,      MANUAL_YN
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM APPS.OKC_K_HISTORY_V;

Dependencies

[top of page]

APPS.OKC_K_HISTORY_V references the following:

APPS: OKC_K_HISTORY_B; OKC_K_HISTORY_TL

APPS.OKC_K_HISTORY_V is referenced by following:

APPS: OKC_HST_PVT - show dependent code; OKC_HST_PVT - show dependent code