eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: OKC.OKC_BUS_DOC_TYPES_B#

Object Details

Object Name:	OKC_BUS_DOC_TYPES_B#
Object Type:	VIEW
Owner:	OKC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DOCUMENT_TYPE	VARCHAR2	(30)	Yes
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes
DOCUMENT_TYPE_CLASS	VARCHAR2	(30)	Yes
PROVISION_ALLOWED_YN	VARCHAR2	(1)	Yes
DOC_PREVIEW_FUNCTION	VARCHAR2	(30)
INTENT	VARCHAR2	(1)
DOC_VIEW_DETAILS_FUNCTION	VARCHAR2	(30)
NOTIFICATION_HEADER_FUNCTION	VARCHAR2	(2000)
CONTRACT_TERMS_FUNCTION	VARCHAR2	(30)
SHOW_EXT_VAR_FLAG	VARCHAR2	(1)	Yes
APPLICATION_ID	NUMBER		Yes
ENABLE_AMEND_SUMMARY_YN	VARCHAR2	(1)	Yes
ENABLE_DELIVERABLES_YN	VARCHAR2	(1)	Yes
SHOW_IN_WORKBENCH_FLAG	VARCHAR2	(1)
DOC_VERSION_VIEW	VARCHAR2	(90)
ENABLE_ATTACHMENTS_YN	VARCHAR2	(1)	Yes
EXTERNAL_USERLIST_PROC	VARCHAR2	(90)
SHOW_IN_LOV_YN	VARCHAR2	(1)
CREATED_BY	NUMBER	(15)	Yes
SHOW_PREVIEW_BTN_YN	VARCHAR2	(1)
TARGET_RESPONSE_DOC_TYPE	VARCHAR2	(30)
CREATION_DATE	DATE		Yes
DISABLE_AMEND_YN	VARCHAR2	(1)
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
START_DATE	DATE
END_DATE	DATE
SHOW_AUTH_PARTY_FLAG	VARCHAR2	(1)
ENABLE_ATTACHED_DOC_FLAG	VARCHAR2	(1)
VARIABLE_RESOLUTION_AM	VARCHAR2	(255)
MULTIPARTIES_ALLOWED_FLAG	VARCHAR2	(1)
ENABLE_CONTRACT_TERMS_YN	VARCHAR2	(1)
LAYOUT_TEMPLATE_ID	NUMBER
ZD_EDITION_NAME	VARCHAR2	(30)	Yes
ALLOW_APPROVER_EDIT_YN	VARCHAR2	(1)
APPROVAL_WORKFLOW_NAME	VARCHAR2	(255)
DELIVERABLE_TOKEN	VARCHAR2	(30)
ENABLE_CONTROLS_YN	VARCHAR2	(1)
ENABLE_NOTES_YN	VARCHAR2	(1)
ENABLE_PARTIES_YN	VARCHAR2	(1)
ENABLE_RELATIONSHIPS_YN	VARCHAR2	(1)
ENABLE_RISKS_YN	VARCHAR2	(1)
HEADER_TOKEN	VARCHAR2	(30)
SIGNATURE_WORKFLOW_NAME	VARCHAR2	(255)
UI_PERS_FUNCTION	VARCHAR2	(30)
AUTO_NUM_ENABLED_YN	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DOCUMENT_TYPE
,      OBJECT_VERSION_NUMBER
,      DOCUMENT_TYPE_CLASS
,      PROVISION_ALLOWED_YN
,      DOC_PREVIEW_FUNCTION
,      INTENT
,      DOC_VIEW_DETAILS_FUNCTION
,      NOTIFICATION_HEADER_FUNCTION
,      CONTRACT_TERMS_FUNCTION
,      SHOW_EXT_VAR_FLAG
,      APPLICATION_ID
,      ENABLE_AMEND_SUMMARY_YN
,      ENABLE_DELIVERABLES_YN
,      SHOW_IN_WORKBENCH_FLAG
,      DOC_VERSION_VIEW
,      ENABLE_ATTACHMENTS_YN
,      EXTERNAL_USERLIST_PROC
,      SHOW_IN_LOV_YN
,      CREATED_BY
,      SHOW_PREVIEW_BTN_YN
,      TARGET_RESPONSE_DOC_TYPE
,      CREATION_DATE
,      DISABLE_AMEND_YN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
,      SHOW_AUTH_PARTY_FLAG
,      ENABLE_ATTACHED_DOC_FLAG
,      VARIABLE_RESOLUTION_AM
,      MULTIPARTIES_ALLOWED_FLAG
,      ENABLE_CONTRACT_TERMS_YN
,      LAYOUT_TEMPLATE_ID
,      ZD_EDITION_NAME
,      ALLOW_APPROVER_EDIT_YN
,      APPROVAL_WORKFLOW_NAME
,      DELIVERABLE_TOKEN
,      ENABLE_CONTROLS_YN
,      ENABLE_NOTES_YN
,      ENABLE_PARTIES_YN
,      ENABLE_RELATIONSHIPS_YN
,      ENABLE_RISKS_YN
,      HEADER_TOKEN
,      SIGNATURE_WORKFLOW_NAME
,      UI_PERS_FUNCTION
,      AUTO_NUM_ENABLED_YN
FROM OKC.OKC_BUS_DOC_TYPES_B#;

Dependencies

[top of page]

OKC.OKC_BUS_DOC_TYPES_B# references the following:

OKC: OKC_BUS_DOC_TYPES_B

OKC.OKC_BUS_DOC_TYPES_B# is referenced by following:

APPS: OKC_BUS_DOC_TYPES_B; OKC_BUS_DOC_TYPES_B+; OKC_BUS_DOC_TYPES_SEC