Product: | OKS - Service Contracts |
---|---|
Description: | This table is used to hold default values used when renewing a service contract or when creating a service contract from an order.The defaults can either be a "Master" default, where CDT_TYPE = 'MDT', or a "Segmented" default, where CDT_TYP |
Implementation/DBA Data: | APPS.OKS_K_DEFAULTS_V |
SELECT CDT.ROWID ROW_ID
, CDT.ID ID
, CDT.CDT_TYPE CDT_TYPE
, CDT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CDT.CREATED_BY CREATED_BY
, CDT.CREATION_DATE CREATION_DATE
, CDT.LAST_UPDATED_BY LAST_UPDATED_BY
, CDT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CDT.SEGMENT_ID1 SEGMENT_ID1
, CDT.SEGMENT_ID2 SEGMENT_ID2
, CDT.JTOT_OBJECT_CODE JTOT_OBJECT_CODE
, CDT.PDF_ID PDF_ID
, CDT.QCL_ID QCL_ID
, CDT.CGP_NEW_ID CGP_NEW_ID
, CDT.CGP_RENEW_ID CGP_RENEW_ID
, CDT.PRICE_LIST_ID1 PRICE_LIST_ID1
, CDT.PRICE_LIST_ID2 PRICE_LIST_ID2
, CDT.RENEWAL_TYPE RENEWAL_TYPE
, CDT.PO_REQUIRED_YN PO_REQUIRED_YN
, CDT.RENEWAL_PRICING_TYPE RENEWAL_PRICING_TYPE
, CDT.MARKUP_PERCENT MARKUP_PERCENT
, CDT.RLE_CODE RLE_CODE
, CDT.START_DATE START_DATE
, CDT.END_DATE END_DATE
, CDT.REVENUE_ESTIMATED_PERCENT REVENUE_ESTIMATED_PERCENT
, CDT.REVENUE_ESTIMATED_DURATION REVENUE_ESTIMATED_DURATION
, CDT.REVENUE_ESTIMATED_PERIOD REVENUE_ESTIMATED_PERIOD
, CDT.TEMPLATE_SET_ID TEMPLATE_SET_ID
, CDT.THRESHOLD_CURRENCY THRESHOLD_CURRENCY
, CDT.THRESHOLD_AMOUNT THRESHOLD_AMOUNT
, CDT.EMAIL_ADDRESS EMAIL_ADDRESS
, CDT.BILLING_PROFILE_ID BILLING_PROFILE_ID
, CDT.USER_ID USER_ID
, CDT.THRESHOLD_ENABLED_YN THRESHOLD_ENABLED_YN
, CDT.GRACE_PERIOD GRACE_PERIOD
, CDT.GRACE_DURATION GRACE_DURATION
, CDT.PAYMENT_TERMS_ID1 PAYMENT_TERMS_ID1
, CDT.PAYMENT_TERMS_ID2 PAYMENT_TERMS_ID2
, CDT.EVERGREEN_THRESHOLD_CURR EVERGREEN_THRESHOLD_CURR
, CDT.EVERGREEN_THRESHOLD_AMT EVERGREEN_THRESHOLD_AMT
, CDT.PAYMENT_METHOD PAYMENT_METHOD
, CDT.PAYMENT_THRESHOLD_CURR PAYMENT_THRESHOLD_CURR
, CDT.PAYMENT_THRESHOLD_AMT PAYMENT_THRESHOLD_AMT
, CDT.INTERFACE_PRICE_BREAK INTERFACE_PRICE_BREAK
FROM OKS_K_DEFAULTS CDT