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]

TABLE: OKS.OKS_INST_HIST_DETAILS

Object Details

Object Name:	OKS_INST_HIST_DETAILS
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_INST_HIST_DETAILS
Subobject Name:
Status:	VALID

OKS_INST_HIST_DETAILS contains details of the Contracts covering item instances. The state of the contract(s) before and after the Transaction is recorded, in the form of old and new values. This is the child table of OKS_INSTANCE_HISTORY. INS_ID is the foreign key referencing OKS_INSTANCE_HISTORY table. This table is populated when any Contracts and Contract lines are updated or created as a result of changes to an item instance.
Each row includes
- Existing instance details
- Original contract details before the transaction occurred
- New contract details as a result of the transaction.
- New instance details as a result of the transaction.

The OLD_ columns contain details of the Contract before the transaction occurred.

The NEW_ columns contain details of the updates on existing Contract(s) as well
as details of new Contract(s) created, due to the transactions performed on an Instance.
The number of rows created and the values populated for each field varies from each
transaction type.Two records will be created for "Split"," Replace", "Transfer", "Update"
and one record for "New", "Return", "Terminate" and "Installation Date Change"
For Transaction types "Split", "Replace", "Transfer", "Update" the values populated in the fields are as follows
First record
- INSTANCE_ID_NEW will contain original item instance
- INSTANCE_QTY_OLD will contain original Instance quantity.
- INSTANCE_QTY_NEW will contain the quantity of the Instance after the transaction occurred.
- INSTANCE_AMT_OLD will contain service amount for the original Instance before the
transaction
- INSTANCE_AMT_NEW will contain service amount for the original Instance after the transaction
occurred.
Second record
- INSTANCE_ID_NEW will contain Instance ID of New Instance created as a result of
Split or replace. Incase of "Transfer" and "Update", it contains the original item instance.
- INSTANCE_QTY_OLD will contain original Instance quantity.
- INSTANCE_QTY_NEW will contain the quantity of the New Instance after the transaction.
- INSTANCE_AMT_OLD will contain service amount for the original Instance before the
transaction.
- INSTANCE_AMT_NEW will contain service amount for the new Instance after the transaction.
For Transaction types "New", "Terminate", "Return" and "Installation Date change", the values populated are as follows
- INSTANCE_ID_NEW will contain Instance ID of original item instance.
- INSTANCE_QTY_OLD will contain original Instance quantity.
- INSTANCE_QTY_NEW will contain the original Instance quantity.
- INSTANCE_AMT_OLD will contain service amount for the original Instance before the transaction.
- INSTANCE_AMT_NEW will contain service amount for the new Instance after the transaction.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_INST_HIST_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_INST_HIST_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INS_ID
OKS_INST_HIST_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
INS_ID	NUMBER			Foreign key to OKS_INSTANCE_HISTORY.ID
TRANSACTION_DATE	DATE			Date when the transaction on an Instance occurred.
TRANSACTION_TYPE	VARCHAR2	(40)		Transaction Type (References OKS_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='OKS_TRANSACTION_TYPE'). Valid Values: 'TRM' Terminate Instance 'TRF' Transfer of Instance Ownership 'SPL', Instance quantity Split. 'UPD' Update Instance quantity 'RET' Return Instance 'NEW' New Instance 'IDC' Installation date change.
SYSTEM_ID	NUMBER			System Identifier to which the Instance is a part of. (References CSI_SYSTEMS.SYSTEM_ID)
INSTANCE_ID_NEW	NUMBER			New Instance Id created as a result of the transaction performed in case of transaction type Split and Replace. For Transaction types 'New','Transfer','Return','Terminate', this field stores the original instance id.
INSTANCE_QTY_OLD	NUMBER			Existing Instance Quantity
INSTANCE_QTY_NEW	NUMBER			For transaction type 'Split', this column stores instance quantity of the new Instance created. For transaction type 'Update', this column stores the updated quantity. For the other transactions, will be same as INSTANCE_QTY_OLD.
INSTANCE_AMT_OLD	NUMBER			Existing covered line amount covering the original Instance.
INSTANCE_AMT_NEW	NUMBER			For Transaction types 'Split', 'Replace', 'Transfer', 'Update', the first record will contain service amount for the original Instance after the transaction occurred. The second record will contain service amount for the new Instance after the transaction occurred. For Transaction types 'New', 'Terminate', 'Return' and 'Installation Date change', it will contain service amount for the new Instance after the transaction.
OLD_CONTRACT_ID	NUMBER			Unique Identifier for Contract Header. Id of the old Contract covering the Instance before the Transaction.
OLD_CONTACT_START_DATE	DATE			Start Date of the Contract covering the existing Instance before the Transaction.
OLD_CONTRACT_END_DATE	DATE			End Date of the Contract covering the existing Instance before the Transaction.
NEW_CONTRACT_ID	NUMBER			Unique Identifier for Contract HeaderUnique Identifier for Contract Header. For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return' and 'Installation Date change', Id of the Contract covering the current Instance. For transaction type 'Transfer', the Id of the new Contract created after the transaction.
NEW_CONTACT_START_DATE	DATE			For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return', Start Date of the Contract covering the current Instance, same as OLD_CONTRACT_START_DATE. For transaction type 'Transfer', the start date of the new Contract created after the transaction. For transaction type 'Installation Date change', start date of the contract covering the current instance after the transaction..
NEW_CONTRACT_END_DATE	DATE			For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return', 'Transfer', End Date of the Contract covering the current Instance, same as OLD_CONTRACT_END_DATE. For transaction type 'Installation Date change', end date of the contract covering the current instance after the transaction..
OLD_SERVICE_LINE_ID	NUMBER			Unique Identifier for Contract Line. Id of the Service line covering the Instance, on which the transaction is performed
OLD_SERVICE_START_DATE	DATE			Start date of the old Service line covering the Instance before the Transaction.
OLD_SERVICE_END_DATE	DATE			End date of the old Service line covering the Instance before the Transaction.
NEW_SERVICE_LINE_ID	NUMBER			Unique Identifier for Contract Line. For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return' and 'Installation Date change', Id of the Contract line covering the current Instance. For transaction type 'Transfer', the Id of the new Contract line created after the transaction.
NEW_SERVICE_START_DATE	DATE			For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return', Start Date of the Contract line covering the current Instance, same as OLD_SERVICE_START_DATE. For transaction type 'Transfer', the start date of the new Contract line created after the transaction. For transaction type 'Installation Date change', start date of the contract line covering the current instance after the transaction...
NEW_SERVICE_END_DATE	DATE			End Date of the new Service line covering the Instance after the Transaction.
OLD_SUBLINE_ID	NUMBER			Unique Identifier for Contract Line. Id of the old Covered line covering the Instance before the Transaction.
OLD_SUBLINE_START_DATE	DATE			Start Date of the Covered line covering the Instance before the Transaction.
OLD_SUBLINE_END_DATE	DATE			End Date of the Covered line covering the Instance before the Transaction.
NEW_SUBLINE_ID	NUMBER			Unique Identifier for Contract Line. For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return' and 'Installation Date change', Id of the Contract sub line covering the current Instance. For transaction type 'Transfer', the Id of the new Contract sub line created after the transaction..
NEW_SUBLINE_START_DATE	DATE			For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return', Start Date of the sub line covering the current Instance, same as OLD_SUBLINE_START_DATE. For transaction type 'Transfer', the start date of the new sub line created after the transaction. For transaction type 'Installation Date change', start date of the sub line covering the current instance after the transaction..
NEW_SUBLINE_END_DATE	DATE			For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return', 'Transfer', End Date of the sub line covering the current Instance, same as OLD_SUBLINE_END_DATE. For transaction type 'Installation Date change', end date of the sub line covering the current instance after the transaction.
OLD_CUSTOMER	NUMBER			Customer Account Id of the Contract covering the current instance.
NEW_CUSTOMER	NUMBER			For transaction types 'Split', 'Replace', 'Update', 'Terminate', 'Return', 'Installation date change', Customer account Id the Contract covering the current Instance, same as OLD_CUSTOMER. For transaction type 'Transfer', the Customer account id of the new Contract created after the transaction.
OLD_K_STATUS	VARCHAR2	(200)		Status of the Contract covering the instance.
NEW_K_STATUS	VARCHAR2	(200)		For transaction types 'Split','Replace', 'Update', 'Terminate', 'Return', same as OLD_K_STATUS For transaction types 'Transfer', status fo the new Contract created. For transaction type 'Installation date change', status of the Contract after the transaction occurred.
SUBLINE_DATE_TERMINATED	DATE			Termination date of the sub line. Will be populated only for transaction type 'Return','Terminate' and 'Transfer',
TRANSFER_OPTION	VARCHAR2	(200)		Coverage Transfer Option assoicated to the service line (References FND_LOOKUP.lookup_code with LOOKUP_TYPE='OKS_TRANSFER_OPTIONS')
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

Query Text

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


SELECT 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 OKS.OKS_INST_HIST_DETAILS;

Dependencies

[top of page]

OKS.OKS_INST_HIST_DETAILS does not reference any database object

OKS.OKS_INST_HIST_DETAILS is referenced by following:

APPS: OKS_INST_HIST_DETAILS