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

Object Details

Object Name:	OKS_INST_HIST_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_INST_HIST_DETAILS_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ID	NUMBER		Yes
INS_ID	NUMBER
TRANSACTION_DATE	DATE
TRANSACTION_TYPE	VARCHAR2	(40)
SYSTEM_ID	NUMBER
INSTANCE_ID_NEW	NUMBER
INSTANCE_QTY_OLD	NUMBER
INSTANCE_QTY_NEW	NUMBER
INSTANCE_AMT_OLD	NUMBER
INSTANCE_AMT_NEW	NUMBER
OLD_CONTRACT_ID	NUMBER
OLD_CONTACT_START_DATE	DATE
OLD_CONTRACT_END_DATE	DATE
NEW_CONTRACT_ID	NUMBER
NEW_CONTACT_START_DATE	DATE
NEW_CONTRACT_END_DATE	DATE
OLD_SERVICE_LINE_ID	NUMBER
OLD_SERVICE_START_DATE	DATE
OLD_SERVICE_END_DATE	DATE
NEW_SERVICE_LINE_ID	NUMBER
NEW_SERVICE_START_DATE	DATE
NEW_SERVICE_END_DATE	DATE
OLD_SUBLINE_ID	NUMBER
OLD_SUBLINE_START_DATE	DATE
OLD_SUBLINE_END_DATE	DATE
NEW_SUBLINE_ID	NUMBER
NEW_SUBLINE_START_DATE	DATE
NEW_SUBLINE_END_DATE	DATE
OLD_CUSTOMER	NUMBER
NEW_CUSTOMER	NUMBER
OLD_K_STATUS	VARCHAR2	(200)
NEW_K_STATUS	VARCHAR2	(200)
SUBLINE_DATE_TERMINATED	DATE
TRANSFER_OPTION	VARCHAR2	(200)
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
DATE_CANCELLED	DATE			Sub line date canceled. This column is used to identify the date_canceled on entered sub lines for Installed Base operations like Instance termination, ownership change etc.

Query Text

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


SELECT ROW_ID
,      ID
,      INS_ID
,      TRANSACTION_DATE
,      TRANSACTION_TYPE
,      SYSTEM_ID
,      INSTANCE_ID_NEW
,      INSTANCE_QTY_OLD
,      INSTANCE_QTY_NEW
,      INSTANCE_AMT_OLD
,      INSTANCE_AMT_NEW
,      OLD_CONTRACT_ID
,      OLD_CONTACT_START_DATE
,      OLD_CONTRACT_END_DATE
,      NEW_CONTRACT_ID
,      NEW_CONTACT_START_DATE
,      NEW_CONTRACT_END_DATE
,      OLD_SERVICE_LINE_ID
,      OLD_SERVICE_START_DATE
,      OLD_SERVICE_END_DATE
,      NEW_SERVICE_LINE_ID
,      NEW_SERVICE_START_DATE
,      NEW_SERVICE_END_DATE
,      OLD_SUBLINE_ID
,      OLD_SUBLINE_START_DATE
,      OLD_SUBLINE_END_DATE
,      NEW_SUBLINE_ID
,      NEW_SUBLINE_START_DATE
,      NEW_SUBLINE_END_DATE
,      OLD_CUSTOMER
,      NEW_CUSTOMER
,      OLD_K_STATUS
,      NEW_K_STATUS
,      SUBLINE_DATE_TERMINATED
,      TRANSFER_OPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      DATE_CANCELLED
FROM APPS.OKS_INST_HIST_DETAILS_V;

Dependencies

[top of page]

APPS.OKS_INST_HIST_DETAILS_V references the following:

APPS: OKS_INST_HIST_DETAILS

APPS.OKS_INST_HIST_DETAILS_V is referenced by following:

APPS: OKS_IHD_PVT - show dependent code; OKS_IHD_PVT - show dependent code