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_K_DEFAULTS

Object Details

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

This table is used to hold default values that are to be used when renewing a service contract or when creating a service contract from an order. This table is populated through Global Contracts Defaults UI. The defaults can either be a "Master" default or a "Segmented" default. Only one record within this table can be a Master default record. In segmented defaults sections, either organization (operating unit) or party details can be entered. When renewing a service the default values are initially obtained from information within the Contract. If information is missing from the Contract then default values are pulled from this table in the following order of precedence (1) retrieved against the party, matched to the signatory party in the contract header, (2) defaults stored against the same operating unit as the contract, (3) The Master default record.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_K_DEFAULTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_K_DEFAULTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEGMENT_ID1
OKS_K_DEFAULTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CDT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Surrogate key used for primary unique identifiers
CDT_TYPE	VARCHAR2	(3)	Yes	Indicates if this is the Master ('MDT') default or a Segmented ('SDT') default
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.
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.
SEGMENT_ID1	VARCHAR2	(40)		Primary key to OKX view identifying party or org. Identifies the party or org in the Source (JTOT_OBJECT_CODE).
SEGMENT_ID2	VARCHAR2	(40)		Not being used
JTOT_OBJECT_CODE	VARCHAR2	(30)		JTF Object code identifying the OKX view for party or org. Identifies the Source Object (Table/View/Object) that contains the party or org.
PDF_ID	NUMBER			Process definition id to be used as approval workflow upon renewal.
QCL_ID	NUMBER			QA check list id to be used to QA the contract.
CGP_NEW_ID	NUMBER			Contract group id to be used at the time of creating contracts from order management. This will be the contract group for the new contract.
CGP_RENEW_ID	NUMBER			Contract group id to be used at the time of renewal. This will be the contract group for renewed contract.
PRICE_LIST_ID1	VARCHAR2	(40)		Primary key for price list used in repricing or capping
PRICE_LIST_ID2	VARCHAR2	(40)		Not being used.
RENEWAL_TYPE	VARCHAR2	(30)		How contract is to be handled on renewal. Valid values are 'DNR' (Do Not Renew), 'EVN' (Active Contract), 'NSR' (Notify Salesrep), 'SFA' (Submit for Approval), and 'ERN' (Electronic Renewal).
PO_REQUIRED_YN	VARCHAR2	(3)		Flag to determine if a PO is required before renewal can be billed
RENEWAL_PRICING_TYPE	VARCHAR2	(3)		Determines how renewal is to be repriced. Valid values are 'MAN' (Manual), 'PCT' (Markup Percent) and 'LST' (Price List).
MARKUP_PERCENT	NUMBER	(5)		Markup / markdown percent to be used for renewal contract if RENEWAL_PRICING_TYPE = 'PCT' (Markup Percent).
START_DATE	DATE			Used only with Segment Defaults i.e. Party or Organization. Specifies the date from when the Segment default will be active.
END_DATE	DATE			Used only with Segment Defaults i.e. Party or Organization. Specifies the date when the Segment default is no longer used
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
RLE_CODE	VARCHAR2	(30)		Defines the Party Role. Valid values are 'CUSTOMER', 'DEALER', 'MERCHANT', 'SUBSCRIBER' and 'THIRD_PARTY'. Used for creating contract from order and will create the contact role of that contract.
REVENUE_ESTIMATED_PERCENT	NUMBER	(5)		Defaults the Estimated Percent in the Authoring Form for forecasting.
REVENUE_ESTIMATED_DURATION	NUMBER			Defaults the Estimated Duration in the Authoring Form.
REVENUE_ESTIMATED_PERIOD	VARCHAR2	(20)		Defaults the Estimated Period in the Authoring Form.
TEMPLATE_SET_ID	NUMBER			Primary key for the template used for Electronic Renewals. Specifies when to send Quote or Cover letters to the party.
THRESHOLD_CURRENCY	VARCHAR2	(30)		Currency Code of the THRESHOLD_AMOUNT
THRESHOLD_AMOUNT	NUMBER			If the contract value is less than this threshold amount, then the contract initiates the electronic renewal process; otherwise it follows the normal renewal process.
EMAIL_ADDRESS	VARCHAR2	(2000)		Help desk email address. This will be the 'From' address while sending emails to customer during electronic Renewal.
BILLING_PROFILE_ID	NUMBER			Unique Identifier for Billing Profile.
USER_ID	NUMBER			User Id of Help Desk. This is used to send failure notification during electronic renewal.
THRESHOLD_ENABLED_YN	VARCHAR2	(3)		Flag that specifies whether the threshold amount check is enforced on electronic renewal.
GRACE_PERIOD	VARCHAR2	(20)		UOM for Grace Duration.
GRACE_DURATION	NUMBER			Numerical value that denotes the Grace duration, used together with the GRACE_PERIOD. Contract will be eligible for entitlements till that date.
PAYMENT_TERMS_ID1	VARCHAR2	(40)		Primary key for payment terms. Specifies the preferred default Payment Terms for Electronic Renewal
PAYMENT_TERMS_ID2	VARCHAR2	(40)		Not being used.
EVERGREEN_THRESHOLD_CURR	VARCHAR2	(30)		Currency Code for the EVERGREEN_THRESHOLD_AMT
EVERGREEN_THRESHOLD_AMT	NUMBER			If the contract's total value is below the EVERGREEN_THRESHOLD_AMT, the new contract is treated as evergreen contract.
PAYMENT_METHOD	VARCHAR2	(3)		No longer used
PAYMENT_THRESHOLD_CURR	VARCHAR2	(30)		The code of the currency in which the payment will be made.
PAYMENT_THRESHOLD_AMT	NUMBER			If the contract total amount is below the PAYMENT_THRESHOLD_AMT then the payment must be collected by the means stated in the payment method for electronic renewal
INTERFACE_PRICE_BREAK	VARCHAR2	(3)		A flag which instructs the billing engine to send Usage Price Break information to AR.
CREDIT_AMOUNT	VARCHAR2	(50)		When/If a contract service is terminated; the CREDIT_AMOUNT specifies the method in which to credit the Party. Values are 'FULL', (return the full value of the contract to the party) 'NONE' (return nothing to the party), and 'CALCULATED' (return a calculated or pro-rated amount to the party).
BASE_CURRENCY	VARCHAR2	(30)
APPROVAL_TYPE	VARCHAR2	(30)
EVERGREEN_APPROVAL_TYPE	VARCHAR2	(30)
ONLINE_APPROVAL_TYPE	VARCHAR2	(30)
PURCHASE_ORDER_FLAG	VARCHAR2	(3)
CREDIT_CARD_FLAG	VARCHAR2	(3)
WIRE_FLAG	VARCHAR2	(3)
COMMITMENT_NUMBER_FLAG	VARCHAR2	(3)
CHECK_FLAG	VARCHAR2	(3)
PERIOD_TYPE	VARCHAR2	(10)
PERIOD_START	VARCHAR2	(30)
PRICE_UOM	VARCHAR2	(10)
TEMPLATE_LANGUAGE	VARCHAR2	(50)

Query Text

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


SELECT ID
,      CDT_TYPE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SEGMENT_ID1
,      SEGMENT_ID2
,      JTOT_OBJECT_CODE
,      PDF_ID
,      QCL_ID
,      CGP_NEW_ID
,      CGP_RENEW_ID
,      PRICE_LIST_ID1
,      PRICE_LIST_ID2
,      RENEWAL_TYPE
,      PO_REQUIRED_YN
,      RENEWAL_PRICING_TYPE
,      MARKUP_PERCENT
,      START_DATE
,      END_DATE
,      SECURITY_GROUP_ID
,      RLE_CODE
,      REVENUE_ESTIMATED_PERCENT
,      REVENUE_ESTIMATED_DURATION
,      REVENUE_ESTIMATED_PERIOD
,      TEMPLATE_SET_ID
,      THRESHOLD_CURRENCY
,      THRESHOLD_AMOUNT
,      EMAIL_ADDRESS
,      BILLING_PROFILE_ID
,      USER_ID
,      THRESHOLD_ENABLED_YN
,      GRACE_PERIOD
,      GRACE_DURATION
,      PAYMENT_TERMS_ID1
,      PAYMENT_TERMS_ID2
,      EVERGREEN_THRESHOLD_CURR
,      EVERGREEN_THRESHOLD_AMT
,      PAYMENT_METHOD
,      PAYMENT_THRESHOLD_CURR
,      PAYMENT_THRESHOLD_AMT
,      INTERFACE_PRICE_BREAK
,      CREDIT_AMOUNT
,      BASE_CURRENCY
,      APPROVAL_TYPE
,      EVERGREEN_APPROVAL_TYPE
,      ONLINE_APPROVAL_TYPE
,      PURCHASE_ORDER_FLAG
,      CREDIT_CARD_FLAG
,      WIRE_FLAG
,      COMMITMENT_NUMBER_FLAG
,      CHECK_FLAG
,      PERIOD_TYPE
,      PERIOD_START
,      PRICE_UOM
,      TEMPLATE_LANGUAGE
FROM OKS.OKS_K_DEFAULTS;

Dependencies

[top of page]

OKS.OKS_K_DEFAULTS does not reference any database object

OKS.OKS_K_DEFAULTS is referenced by following:

OKS: OKS_K_DEFAULTS#