[Home] [Help] [Dependency Information]
Object Name: | OKS_K_DEFAULTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_K_DEFAULTS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Rowid Of the Base Table | |
ID | NUMBER | Yes | Surrogate key used for primary unique identifiers | |
CDT_TYPE | VARCHAR2 | (3) | Yes | Indicates if this is the Master default or a segmented 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 | 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. | |
SEGMENT_ID1 | VARCHAR2 | (40) | First part of primary key to OKX view identifying part or org. | |
SEGMENT_ID2 | VARCHAR2 | (40) | Second part of primary key to OKX view identifying part or org. | |
JTOT_OBJECT_CODE | VARCHAR2 | (30) | JTF Ojbect code identifying the OKX view for 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 contract upon renewal | ||
CGP_NEW_ID | NUMBER | Id of contract group into which to place a new contract from order | ||
CGP_RENEW_ID | NUMBER | Id of contract group into which to place a renewed contract | ||
PRICE_LIST_ID1 | VARCHAR2 | (40) | First part of primary key for price list used in repricing or capping | |
PRICE_LIST_ID2 | VARCHAR2 | (40) | Second part of primary key for price list used in repricing or capping | |
RENEWAL_TYPE | VARCHAR2 | (30) | How contract is to be handled on renewal | |
PO_REQUIRED_YN | VARCHAR2 | (3) | If a PO is required before renewal can be billed. Yes or No | |
RENEWAL_PRICING_TYPE | VARCHAR2 | (3) | How renewal is to be repriced | |
MARKUP_PERCENT | NUMBER | (5) | Markup/markdown percent to be used if renewal is reprice by percentage | |
RLE_CODE | VARCHAR2 | (30) | Role Code | |
START_DATE | DATE | Beginning effectivity for segmented default | ||
END_DATE | DATE | Ending effectivity for segmented default | ||
REVENUE_ESTIMATED_PERCENT | NUMBER | (5) | Revenue Estimated Percent | |
REVENUE_ESTIMATED_DURATION | NUMBER | Revenue Estimated Duration | ||
REVENUE_ESTIMATED_PERIOD | VARCHAR2 | (20) | Revenue Estimated Period | |
TEMPLATE_SET_ID | NUMBER | The primary key of the template set. | ||
THRESHOLD_CURRENCY | VARCHAR2 | (30) | Threshold currency code. | |
THRESHOLD_AMOUNT | NUMBER | Threshold amount. | ||
EMAIL_ADDRESS | VARCHAR2 | (2000) | Help desk email address. | |
BILLING_PROFILE_ID | NUMBER | Billing profile id. | ||
USER_ID | NUMBER | User id of the admin receiving emails. | ||
THRESHOLD_ENABLED_YN | VARCHAR2 | (3) | Threshold enabled flag. | |
GRACE_PERIOD | VARCHAR2 | (20) | Grace Period | |
GRACE_DURATION | NUMBER | Grace Duration | ||
PAYMENT_TERMS_ID1 | VARCHAR2 | (40) | Pyament Terms ID1 | |
PAYMENT_TERMS_ID2 | VARCHAR2 | (40) | Payment Terms Id2 | |
EVERGREEN_THRESHOLD_CURR | VARCHAR2 | (30) | Evergreen Threshold currency code. | |
EVERGREEN_THRESHOLD_AMT | NUMBER | Evergreen Threshold amount. | ||
PAYMENT_METHOD | VARCHAR2 | (3) | Payment Method for Contract Threshold | |
PAYMENT_THRESHOLD_CURR | VARCHAR2 | (30) | Payment Threshold currency code. | |
PAYMENT_THRESHOLD_AMT | NUMBER | Payment Threshold amount. | ||
INTERFACE_PRICE_BREAK | VARCHAR2 | (3) | ||
CREDIT_AMOUNT | VARCHAR2 | (50) | ||
PERIOD_TYPE | VARCHAR2 | (10) | ||
PERIOD_START | VARCHAR2 | (30) | ||
PRICE_UOM | VARCHAR2 | (10) | ||
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) | ||
TEMPLATE_LANGUAGE | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, RLE_CODE
, START_DATE
, END_DATE
, 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
, PERIOD_TYPE
, PERIOD_START
, PRICE_UOM
, BASE_CURRENCY
, APPROVAL_TYPE
, EVERGREEN_APPROVAL_TYPE
, ONLINE_APPROVAL_TYPE
, PURCHASE_ORDER_FLAG
, CREDIT_CARD_FLAG
, WIRE_FLAG
, COMMITMENT_NUMBER_FLAG
, CHECK_FLAG
, TEMPLATE_LANGUAGE
FROM APPS.OKS_K_DEFAULTS_V;
|
|
|