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_BATCH_RULES_V

Object Details

Object Name:	OKS_BATCH_RULES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

This table is populated, when a Mass Terminate or Transfer batch is created and user enters the contracts rules for the batch.
The contract rules defined for a 'Terminate' batch determine the credit option and the termination reason to be applied on the contract terminated. A 'Full', 'Partial' or 'No' credit will be issued for the associated services.
The Contract rules defined for a 'Transfer' batch determines the affect on associated services due to instance transfers. The transfer option defined will determine the impact on the contracts.
'COVERAGE' - Terminates and transfers the services based on the coverage transfer option.
'NO CHANGE' - No updates to the Contracts. 'TERMINATE' - Services terminated and no new contract created.
'TRANSFER' -Terminates and transfers the services.
The new Contracts will be created with the billto/ship accounts , status as defined in the rules.
The billing profile will determine the billing rules for the new contract.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Instance Mass Update Batch Identifier
BATCH_TYPE	VARCHAR2	(30)		Identifies the batch type. Valid Values. 'XFER' -Mass Transfer batches, 'TRM' -For Mass Terminate batches, 'GEN' - For General batches, 'MOVE' - For Mass Move batches
BATCH_SOURCE	VARCHAR2	(30)		Identifies Source of the batch. Not Used.
TRANSACTION_DATE	DATE			Date when a transaction on an Instance occurred. Date of transfer owner for Transfer batches. Termination date for Terminate batches.
CREDIT_OPTION	VARCHAR2	(30)		The Credit option required to calculate credit for when contract line is terminated in Mass Terminate and Mass Transfer batch.. Valid values - FULL, CALCULATED, NONE
TERMINATION_REASON_CODE	VARCHAR2	(30)		The reason for terminating the original lines, Derived from fnd lookups where lookup type 'OKC_TERMINATION_REASONS'.
BILLING_PROFILE_ID	NUMBER			The Billing profile to determine the billing rules for the new Contract. Foreign key to OKS_BILLING_RPOFILES.ID
RETAIN_CONTRACT_NUMBER_FLAG	VARCHAR2	(1)		Indicates if the original Contract number is to be copied to the new Contract. Valid values 'Y' - Yes, 'N' - No
CONTRACT_MODIFIER	VARCHAR2	(120)		Contract Modifier for the new Contract. Will be applied to all contracts created for transferred services
CONTRACT_STATUS	VARCHAR2	(30)		The status of the new Contract created due to instance transfer.
TRANSFER_NOTES_FLAG	VARCHAR2	(1)		Indicates if the transfer notes from Original Contract header should be copied to the new Contract. Valid values 'Y' - Yes, 'N' - No
TRANSFER_ATTACHMENTS_FLAG	VARCHAR2	(1)		Indicates if the transfer attachments from Original Contract should be copied to the new Contract. Valid values 'Y' - Yes, 'N' - No
BILL_LINES_FLAG	VARCHAR2	(1)		Indicates if the transferred line should be billed in the new Contract. Valid values 'Y' - Yes, 'N' - No, 'R' - At Renewal.
TRANSFER_OPTION_CODE	VARCHAR2	(30)		Transfer option defined for the batch. Values from fnd_lookups where lookup_type like 'OKS_TRANSFER_RULES'. Valid Values 'COVERAGE' - Use Coverage Terms. 'NO CHANGE' - No Changes to the Contracts. 'TERMINATE' - Terminate the Contracts. 'TRANSFER' - Transfer and Terminate the Contracts.
BILL_ACCOUNT_ID	NUMBER			Holds bill to customer account id for a Transfer batch. Used when creating a Contract for the new Owner.
SHIP_ACCOUNT_ID	NUMBER			Holds ship to customer account id for a Transfer batch.Used when creating a Contract for the new Owner.
BILL_ADDRESS_ID	NUMBER			Holds Bill To Address id for a Transfer batch.Used when creating a Contract for the new Owner.
SHIP_ADDRESS_ID	NUMBER			Holds ship to address id for a Transfer batch.Used when creating a Contract for the new Owner.
BILL_CONTACT_ID	NUMBER			Holds Bill To Contact id for a Transfer batch.Used when creating a Contract for the new Owner.
NEW_ACCOUNT_ID	NUMBER			Holds the new owner account ID for instance transfers.
CREATED_BY	NUMBER		Yes	ID of the user who created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER		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			OS ID of the user who last updated the record.
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
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.
REQUEST_ID	NUMBER			Unique Identifier of a concurrent request.

Query Text

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


SELECT BATCH_ID
,      BATCH_TYPE
,      BATCH_SOURCE
,      TRANSACTION_DATE
,      CREDIT_OPTION
,      TERMINATION_REASON_CODE
,      BILLING_PROFILE_ID
,      RETAIN_CONTRACT_NUMBER_FLAG
,      CONTRACT_MODIFIER
,      CONTRACT_STATUS
,      TRANSFER_NOTES_FLAG
,      TRANSFER_ATTACHMENTS_FLAG
,      BILL_LINES_FLAG
,      TRANSFER_OPTION_CODE
,      BILL_ACCOUNT_ID
,      SHIP_ACCOUNT_ID
,      BILL_ADDRESS_ID
,      SHIP_ADDRESS_ID
,      BILL_CONTACT_ID
,      NEW_ACCOUNT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
FROM APPS.OKS_BATCH_RULES_V;

Dependencies

[top of page]

APPS.OKS_BATCH_RULES_V references the following:

APPS: OKS_BATCH_RULES

APPS.OKS_BATCH_RULES_V is referenced by following:

APPS: OKS_BRL_PVT - show dependent code; OKS_BRL_PVT - show dependent code