OKC_BUS_DOC_TYPES

Details

Schema: FUSION
Object owner: OKC
Object type: VIEW

Columns

Name
ROW_ID DOCUMENT_TYPE OBJECT_VERSION_NUMBER NAME DESCRIPTION INTENT PROVISION_ALLOWED_YN DOCUMENT_TYPE_CLASS DOC_PREVIEW_FUNCTION DOC_VIEW_DETAILS_FUNCTION NOTIFICATION_HEADER_FUNCTION SHOW_EXT_VAR_FLAG CONTRACT_TERMS_FUNCTION ENABLE_AMEND_SUMMARY_YN ENABLE_DELIVERABLES_YN SHOW_IN_WORKBENCH_FLAG DOC_VERSION_VIEW ENABLE_ATTACHMENTS_YN APPLICATION_ID EXTERNAL_USERLIST_PROC SHOW_IN_LOV_YN SHOW_PREVIEW_BTN_YN TARGET_RESPONSE_DOC_TYPE DISABLE_AMEND_YN START_DATE END_DATE SHOW_AUTH_PARTY_FLAG ENABLE_ATTACHED_DOC_FLAG VARIABLE_RESOLUTION_AM MULTIPARTIES_ALLOWED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN VARIABLE_RESOLUTION_HEADER_VO VARIABLE_RESOLUTION_LINES_VO MODULE_ID

Name

ROW_ID

DOCUMENT_TYPE

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

INTENT

PROVISION_ALLOWED_YN

DOCUMENT_TYPE_CLASS

DOC_PREVIEW_FUNCTION

DOC_VIEW_DETAILS_FUNCTION

NOTIFICATION_HEADER_FUNCTION

SHOW_EXT_VAR_FLAG

CONTRACT_TERMS_FUNCTION

ENABLE_AMEND_SUMMARY_YN

ENABLE_DELIVERABLES_YN

SHOW_IN_WORKBENCH_FLAG

DOC_VERSION_VIEW

ENABLE_ATTACHMENTS_YN

APPLICATION_ID

EXTERNAL_USERLIST_PROC

SHOW_IN_LOV_YN

SHOW_PREVIEW_BTN_YN

TARGET_RESPONSE_DOC_TYPE

DISABLE_AMEND_YN

START_DATE

END_DATE

SHOW_AUTH_PARTY_FLAG

ENABLE_ATTACHED_DOC_FLAG

VARIABLE_RESOLUTION_AM

MULTIPARTIES_ALLOWED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

VARIABLE_RESOLUTION_HEADER_VO

VARIABLE_RESOLUTION_LINES_VO

MODULE_ID

Query

SQL_Statement
SELECT BDTB.ROWID ROW_ID, BDTB.DOCUMENT_TYPE DOCUMENT_TYPE, BDTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BDTTL.NAME NAME, BDTTL.DESCRIPTION DESCRIPTION, BDTB.INTENT INTENT, BDTB.PROVISION_ALLOWED_YN PROVISION_ALLOWED_YN, BDTB.DOCUMENT_TYPE_CLASS DOCUMENT_TYPE_CLASS, BDTB.DOC_PREVIEW_FUNCTION DOC_PREVIEW_FUNCTION, BDTB.DOC_VIEW_DETAILS_FUNCTION DOC_VIEW_DETAILS_FUNCTION, BDTB.NOTIFICATION_HEADER_FUNCTION NOTIFICATION_HEADER_FUNCTION, BDTB.SHOW_EXT_VAR_FLAG SHOW_EXT_VAR_FLAG, BDTB.CONTRACT_TERMS_FUNCTION CONTRACT_TERMS_FUNCTION, BDTB.ENABLE_AMEND_SUMMARY_YN ENABLE_AMEND_SUMMARY_YN, BDTB.ENABLE_DELIVERABLES_YN ENABLE_DELIVERABLES_YN, BDTB.SHOW_IN_WORKBENCH_FLAG SHOW_IN_WORKBENCH_FLAG, BDTB.DOC_VERSION_VIEW DOC_VERSION_VIEW, BDTB.ENABLE_ATTACHMENTS_YN ENABLE_ATTACHMENTS_YN, BDTB.APPLICATION_ID APPLICATION_ID, BDTB.EXTERNAL_USERLIST_PROC EXTERNAL_USERLIST_PROC, BDTB.SHOW_IN_LOV_YN SHOW_IN_LOV_YN, BDTB.SHOW_PREVIEW_BTN_YN SHOW_PREVIEW_BTN_YN, BDTB.TARGET_RESPONSE_DOC_TYPE TARGET_RESPONSE_DOC_TYPE, BDTB.DISABLE_AMEND_YN DISABLE_AMEND_YN, BDTB.START_DATE START_DATE, BDTB.END_DATE END_DATE, BDTB.SHOW_AUTH_PARTY_FLAG, BDTB.ENABLE_ATTACHED_DOC_FLAG, BDTB.VARIABLE_RESOLUTION_AM, BDTB.MULTIPARTIES_ALLOWED_FLAG MULTIPARTIES_ALLOWED_FLAG, BDTB.CREATED_BY CREATED_BY, BDTB.CREATION_DATE CREATION_DATE, BDTB.LAST_UPDATED_BY LAST_UPDATED_BY, BDTB.LAST_UPDATE_DATE LAST_UPDATE_DATE, BDTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BDTB.VARIABLE_RESOLUTION_HEADER_VO VARIABLE_RESOLUTION_HEADER_VO, BDTB.VARIABLE_RESOLUTION_LINES_VO VARIABLE_RESOLUTION_LINES_VO, BDTB.MODULE_ID MODULE_ID FROM OKC_BUS_DOC_TYPES_B BDTB, OKC_BUS_DOC_TYPES_TL BDTTL WHERE BDTB.DOCUMENT_TYPE = BDTTL.DOCUMENT_TYPE AND BDTTL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

BDTB.ROWID ROW_ID,

BDTB.DOCUMENT_TYPE DOCUMENT_TYPE,

BDTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

BDTTL.NAME NAME,

BDTTL.DESCRIPTION DESCRIPTION,

BDTB.INTENT INTENT,

BDTB.PROVISION_ALLOWED_YN PROVISION_ALLOWED_YN,

BDTB.DOCUMENT_TYPE_CLASS DOCUMENT_TYPE_CLASS,

BDTB.DOC_PREVIEW_FUNCTION DOC_PREVIEW_FUNCTION,

BDTB.DOC_VIEW_DETAILS_FUNCTION DOC_VIEW_DETAILS_FUNCTION,

BDTB.NOTIFICATION_HEADER_FUNCTION NOTIFICATION_HEADER_FUNCTION,

BDTB.SHOW_EXT_VAR_FLAG SHOW_EXT_VAR_FLAG,

BDTB.CONTRACT_TERMS_FUNCTION CONTRACT_TERMS_FUNCTION,

BDTB.ENABLE_AMEND_SUMMARY_YN ENABLE_AMEND_SUMMARY_YN,

BDTB.ENABLE_DELIVERABLES_YN ENABLE_DELIVERABLES_YN,

BDTB.SHOW_IN_WORKBENCH_FLAG SHOW_IN_WORKBENCH_FLAG,

BDTB.DOC_VERSION_VIEW DOC_VERSION_VIEW,

BDTB.ENABLE_ATTACHMENTS_YN ENABLE_ATTACHMENTS_YN,

BDTB.APPLICATION_ID APPLICATION_ID,

BDTB.EXTERNAL_USERLIST_PROC EXTERNAL_USERLIST_PROC,

BDTB.SHOW_IN_LOV_YN SHOW_IN_LOV_YN,

BDTB.SHOW_PREVIEW_BTN_YN SHOW_PREVIEW_BTN_YN,

BDTB.TARGET_RESPONSE_DOC_TYPE TARGET_RESPONSE_DOC_TYPE,

BDTB.DISABLE_AMEND_YN DISABLE_AMEND_YN,

BDTB.START_DATE START_DATE,

BDTB.END_DATE END_DATE,

BDTB.SHOW_AUTH_PARTY_FLAG,

BDTB.ENABLE_ATTACHED_DOC_FLAG,

BDTB.VARIABLE_RESOLUTION_AM,

BDTB.MULTIPARTIES_ALLOWED_FLAG MULTIPARTIES_ALLOWED_FLAG,

BDTB.CREATED_BY CREATED_BY,

BDTB.CREATION_DATE CREATION_DATE,

BDTB.LAST_UPDATED_BY LAST_UPDATED_BY,

BDTB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

BDTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

BDTB.VARIABLE_RESOLUTION_HEADER_VO VARIABLE_RESOLUTION_HEADER_VO,

BDTB.VARIABLE_RESOLUTION_LINES_VO VARIABLE_RESOLUTION_LINES_VO,

BDTB.MODULE_ID MODULE_ID

FROM

OKC_BUS_DOC_TYPES_B BDTB,

OKC_BUS_DOC_TYPES_TL BDTTL

WHERE

BDTB.DOCUMENT_TYPE = BDTTL.DOCUMENT_TYPE AND BDTTL.LANGUAGE = USERENV('LANG')