VIEW: APPS.OKS_K_DEFAULTS_V

Source

View Text - Preformatted

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 , CDT.CREDIT_AMOUNT CREDIT_AMOUNT, CDT.PERIOD_TYPE PERIOD_TYPE, CDT.PERIOD_START PERIOD_START, CDT.PRICE_UOM PRICE_UOM , CDT.BASE_CURRENCY BASE_CURRENCY, CDT.APPROVAL_TYPE APPROVAL_TYPE, CDT.EVERGREEN_APPROVAL_TYPE EVERGREEN_APPROVAL_TYPE, CDT.ONLINE_APPROVAL_TYPE ONLINE_APPROVAL_TYPE, CDT.PURCHASE_ORDER_FLAG PURCHASE_ORDER_FLAG, CDT.CREDIT_CARD_FLAG CREDIT_CARD_FLAG, CDT.WIRE_FLAG WIRE_FLAG, CDT.COMMITMENT_NUMBER_FLAG COMMITMENT_NUMBER_FLAG, CDT.CHECK_FLAG CHECK_FLAG, CDT.TEMPLATE_LANGUAGE TEMPLATE_LANGUAGE FROM OKS_K_DEFAULTS CDT

View Text - HTML Formatted

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
, CDT.CREDIT_AMOUNT CREDIT_AMOUNT
, CDT.PERIOD_TYPE PERIOD_TYPE
, CDT.PERIOD_START PERIOD_START
, CDT.PRICE_UOM PRICE_UOM
, CDT.BASE_CURRENCY BASE_CURRENCY
, CDT.APPROVAL_TYPE APPROVAL_TYPE
, CDT.EVERGREEN_APPROVAL_TYPE EVERGREEN_APPROVAL_TYPE
, CDT.ONLINE_APPROVAL_TYPE ONLINE_APPROVAL_TYPE
, CDT.PURCHASE_ORDER_FLAG PURCHASE_ORDER_FLAG
, CDT.CREDIT_CARD_FLAG CREDIT_CARD_FLAG
, CDT.WIRE_FLAG WIRE_FLAG
, CDT.COMMITMENT_NUMBER_FLAG COMMITMENT_NUMBER_FLAG
, CDT.CHECK_FLAG CHECK_FLAG
, CDT.TEMPLATE_LANGUAGE TEMPLATE_LANGUAGE
FROM OKS_K_DEFAULTS CDT