[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKS_K_DEFAULTS# |
|---|---|
| Object Type: | VIEW |
| Owner: | OKS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | Yes | ||
| CDT_TYPE | VARCHAR2 | (3) | Yes | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| SEGMENT_ID1 | VARCHAR2 | (40) | ||
| SEGMENT_ID2 | VARCHAR2 | (40) | ||
| JTOT_OBJECT_CODE | VARCHAR2 | (30) | ||
| PDF_ID | NUMBER | |||
| QCL_ID | NUMBER | |||
| CGP_NEW_ID | NUMBER | |||
| CGP_RENEW_ID | NUMBER | |||
| PRICE_LIST_ID1 | VARCHAR2 | (40) | ||
| PRICE_LIST_ID2 | VARCHAR2 | (40) | ||
| RENEWAL_TYPE | VARCHAR2 | (30) | ||
| PO_REQUIRED_YN | VARCHAR2 | (3) | ||
| RENEWAL_PRICING_TYPE | VARCHAR2 | (3) | ||
| MARKUP_PERCENT | NUMBER | (5) | ||
| START_DATE | DATE | |||
| END_DATE | DATE | |||
| SECURITY_GROUP_ID | NUMBER | |||
| RLE_CODE | VARCHAR2 | (30) | ||
| REVENUE_ESTIMATED_PERCENT | NUMBER | (5) | ||
| REVENUE_ESTIMATED_DURATION | NUMBER | |||
| REVENUE_ESTIMATED_PERIOD | VARCHAR2 | (20) | ||
| TEMPLATE_SET_ID | NUMBER | |||
| THRESHOLD_CURRENCY | VARCHAR2 | (30) | ||
| THRESHOLD_AMOUNT | NUMBER | |||
| EMAIL_ADDRESS | VARCHAR2 | (2000) | ||
| BILLING_PROFILE_ID | NUMBER | |||
| USER_ID | NUMBER | |||
| THRESHOLD_ENABLED_YN | VARCHAR2 | (3) | ||
| GRACE_PERIOD | VARCHAR2 | (20) | ||
| GRACE_DURATION | NUMBER | |||
| PAYMENT_TERMS_ID1 | VARCHAR2 | (40) | ||
| PAYMENT_TERMS_ID2 | VARCHAR2 | (40) | ||
| EVERGREEN_THRESHOLD_CURR | VARCHAR2 | (30) | ||
| EVERGREEN_THRESHOLD_AMT | NUMBER | |||
| PAYMENT_METHOD | VARCHAR2 | (3) | ||
| PAYMENT_THRESHOLD_CURR | VARCHAR2 | (30) | ||
| PAYMENT_THRESHOLD_AMT | NUMBER | |||
| INTERFACE_PRICE_BREAK | VARCHAR2 | (3) | ||
| CREDIT_AMOUNT | VARCHAR2 | (50) | ||
| 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) |
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#;
OKS
OKS_K_DEFAULTS
APPS
OKS_K_DEFAULTS
|
|
|
|