VIEW: OKS.OKS_K_DEFAULTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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