[Home] [Help]
[Dependency Information]
[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;
APPS
OKS_K_DEFAULTS
APPS
OKS_CDT_PVT
- show dependent code
OKS_CDT_PVT
- show dependent code
OKS_RENEW_UTIL_PVT
- show dependent code
|
|
|
|