VIEW: APPS.OKC_BUS_DOC_TYPES_VL

Source

View Text - Preformatted

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.ENABLE_CONTRACT_TERMS_YN ENABLE_CONTRACT_TERMS_YN, BDTB.LAYOUT_TEMPLATE_ID, 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.signature_workflow_name, BDTB.header_token, BDTB.deliverable_token, BDTB.enable_notes_yn, BDTB.enable_risks_yn, BDTB.enable_controls_yn, BDTB.ui_pers_function, BDTB.Allow_approver_edit_YN, BDTB.Approval_workflow_name Approval_workflow_name, BDTB.Enable_Relationships_yn Enable_Relationships_yn, BDTB.enable_parties_yn enable_parties_yn, BDTB.auto_num_enabled_yn auto_num_enabled_yn 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')

View Text - HTML Formatted

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.ENABLE_CONTRACT_TERMS_YN ENABLE_CONTRACT_TERMS_YN
, BDTB.LAYOUT_TEMPLATE_ID
, 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.SIGNATURE_WORKFLOW_NAME
, BDTB.HEADER_TOKEN
, BDTB.DELIVERABLE_TOKEN
, BDTB.ENABLE_NOTES_YN
, BDTB.ENABLE_RISKS_YN
, BDTB.ENABLE_CONTROLS_YN
, BDTB.UI_PERS_FUNCTION
, BDTB.ALLOW_APPROVER_EDIT_YN
, BDTB.APPROVAL_WORKFLOW_NAME APPROVAL_WORKFLOW_NAME
, BDTB.ENABLE_RELATIONSHIPS_YN ENABLE_RELATIONSHIPS_YN
, BDTB.ENABLE_PARTIES_YN ENABLE_PARTIES_YN
, BDTB.AUTO_NUM_ENABLED_YN AUTO_NUM_ENABLED_YN
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')