1. Tables and Views for Sales and Fusion Service
  2. OKC_CONTRACT_TYPES_VL

OKC_CONTRACT_TYPES_VL

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

CONTRACT_TYPE_ID

NAME

DESCRIPTION

SET_ID

INTENT

START_DATE

END_DATE

LAYOUT_TEMPLATE_ID

QCL_ID

CONTRACT_GROUP_ID

SIGNATURE_REQUIRED_FLAG

LINE_AUTONUMBER_ENABLED_FLAG

INTER_COMPANY_FLAG

INTER_PROJECT_FLAG

ENABLE_BILLING_CTRL_FLAG

BILLING_LIMIT_TYPE

TERMS_ENABLED_FLAG

RISKS_ENABLED_FLAG

INTERACTIONS_ENABLED_FLAG

RELATED_K_ENABLED_FLAG

CONTRACT_LAYOUT_TEMPLATE

TERMS_LAYOUT_TEMPLATE

CONTRACT_TYPE_CODE

PRIMARY_BUYER_ROLE

REQUESTER_CONTACT_ROLE

NOTIFY_BEFORE_EXP_FLAG

DAYS_TO_EXPIRATION

NOTIFY_CONTACT_ROLE

AGREEMENT_ENABLED_FLAG

ALLOW_LINES_FLAG

ALLOW_EXTERNAL_ITEM_FLAG

CONTRACT_CLASS

CONTRACT_NUMB_METHOD

CONTRACT_NUMB_SEQ_CAT

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ITEM_SOURCE_CODE

CONTRACT_NUMB_LEVEL

ENABLE_ELECTRONIC_SIGN_FLAG

CHR_TYPE

SOLUTION_PROVIDER_CODE

LINE_CLASS

PRICING_SYSTEM_CODE

EMAIL_SUBJECT

EMAIL_MESSAGE_TEXT

PRICE_DURING_BILLING_YN

CONTRACT_MODIFIER_FLAG

AMEND_NO_VERSION_FLAG

ESIGN_TEMPLATE_ID

ESIGN_TEMPLATE_FLAG

Query

SQL_Statement

SELECT

LSEB.CONTRACT_TYPE_ID CONTRACT_TYPE_ID,

LSET.NAME NAME,

LSET.DESCRIPTION DESCRIPTION,

LSEB.SET_ID SET_ID,

LSEB.INTENT INTENT,

LSEB.START_DATE START_DATE,

LSEB.END_DATE END_DATE,

LSEB.LAYOUT_TEMPLATE_ID LAYOUT_TEMPLATE_ID,

LSEB.QCL_ID QCL_ID,

LSEB.CONTRACT_GROUP_ID CONTRACT_GROUP_ID,

LSEB.SIGNATURE_REQUIRED_FLAG SIGNATURE_REQUIRED_FLAG,

LSEB.LINE_AUTONUMBER_ENABLED_FLAG LINE_AUTONUMBER_ENABLED_FLAG,

LSEB.INTER_COMPANY_FLAG INTER_COMPANY_FLAG,

LSEB.INTER_PROJECT_FLAG INTER_PROJECT_FLAG,

LSEB.ENABLE_BILLING_CTRL_FLAG ENABLE_BILLING_CTRL_FLAG,

LSEB.BILLING_LIMIT_TYPE BILLING_LIMIT_TYPE,

LSEB.TERMS_ENABLED_FLAG TERMS_ENABLED_FLAG,

LSEB.RISKS_ENABLED_FLAG RISKS_ENABLED_FLAG,

LSEB.INTERACTIONS_ENABLED_FLAG INTERACTIONS_ENABLED_FLAG,

LSEB.RELATED_K_ENABLED_FLAG RELATED_K_ENABLED_FLAG,

LSEB.CONTRACT_LAYOUT_TEMPLATE CONTRACT_LAYOUT_TEMPLATE,

LSEB.TERMS_LAYOUT_TEMPLATE TERMS_LAYOUT_TEMPLATE,

LSEB.CONTRACT_TYPE_CODE CONTRACT_TYPE_CODE,

LSEB.PRIMARY_BUYER_ROLE PRIMARY_BUYER_ROLE,

LSEB.REQUESTER_CONTACT_ROLE REQUESTER_CONTACT_ROLE,

LSEB.NOTIFY_BEFORE_EXP_FLAG NOTIFY_BEFORE_EXP_FLAG,

LSEB.DAYS_TO_EXPIRATION DAYS_TO_EXPIRATION,

LSEB.NOTIFY_CONTACT_ROLE NOTIFY_CONTACT_ROLE,

LSEB.AGREEMENT_ENABLED_FLAG AGREEMENT_ENABLED_FLAG,

LSEB.ALLOW_LINES_FLAG ALLOW_LINES_FLAG,

LSEB.ALLOW_EXTERNAL_ITEM_FLAG ALLOW_EXTERNAL_ITEM_FLAG,

LSEB.CONTRACT_CLASS CONTRACT_CLASS,

LSEB.CONTRACT_NUMB_METHOD CONTRACT_NUMB_METHOD,

LSEB.CONTRACT_NUMB_SEQ_CAT CONTRACT_NUMB_SEQ_CAT,

LSEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

LSEB.CREATED_BY CREATED_BY,

LSEB.CREATION_DATE CREATION_DATE,

LSEB.LAST_UPDATED_BY LAST_UPDATED_BY,

LSEB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

LSEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

LSEB.ITEM_SOURCE_CODE ITEM_SOURCE_CODE,

LSEB.CONTRACT_NUMB_LEVEL,

LSEB.ENABLE_ELECTRONIC_SIGN_FLAG ENABLE_ELECTRONIC_SIGN_FLAG,

LSEB.CHR_TYPE CHR_TYPE,

LSEB.SOLUTION_PROVIDER_CODE SOLUTION_PROVIDER_CODE,

LSEB.LINE_CLASS LINE_CLASS,

LSEB.PRICING_SYSTEM_CODE PRICING_SYSTEM_CODE,

LSET.EMAIL_SUBJECT EMAIL_SUBJECT,

LSET.EMAIL_MESSAGE_TEXT EMAIL_MESSAGE_TEXT,

LSEB.PRICE_DURING_BILLING_YN PRICE_DURING_BILLING_YN,

LSEB.CONTRACT_MODIFIER_FLAG CONTRACT_MODIFIER_FLAG,

LSEB.AMEND_NO_VERSION_FLAG AMEND_NO_VERSION_FLAG,

LSEB.ESIGN_TEMPLATE_ID ESIGN_TEMPLATE_ID,

LSEB.ESIGN_TEMPLATE_FLAG ESIGN_TEMPLATE_FLAG

FROM

OKC_CONTRACT_TYPES_B LSEB,

OKC_CONTRACT_TYPES_TL LSET

WHERE

LSEB.CONTRACT_TYPE_ID = LSET.CONTRACT_TYPE_ID AND LSET.LANGUAGE = USERENV('LANG')