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: APPS.OKC_BUS_DOC_TYPES_VL

Object Details

Object Name:	OKC_BUS_DOC_TYPES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKC.OKC_BUS_DOC_TYPES_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

business document types view definition. This is used for the VO for business document types

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Code that identifies business document type
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
NAME	VARCHAR2	(150)	Yes	Document type name
DESCRIPTION	VARCHAR2	(4000)		User entered description column.
INTENT	VARCHAR2	(1)		Intent of the document type
PROVISION_ALLOWED_YN	VARCHAR2	(1)	Yes	Indicates whether provisions are allowed for this document type
DOCUMENT_TYPE_CLASS	VARCHAR2	(30)	Yes	Group in which the document type belongs to
DOC_PREVIEW_FUNCTION	VARCHAR2	(30)		Preview function to be used in document preview
DOC_VIEW_DETAILS_FUNCTION	VARCHAR2	(30)		Function to be used for viewing document from deliverables page
NOTIFICATION_HEADER_FUNCTION	VARCHAR2	(2000)		Function to be used to get notification header region in deliverable notification
SHOW_EXT_VAR_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether supplier updateable flag is to be shown in the UI or not
CONTRACT_TERMS_FUNCTION	VARCHAR2	(30)		Function for contract terms page. Foreign key to FND_FORM_FUNCTION table
ENABLE_AMEND_SUMMARY_YN	VARCHAR2	(1)	Yes	Flag to display / hide amendment summary button on the UI
ENABLE_DELIVERABLES_YN	VARCHAR2	(1)	Yes	Flag to enable / disable deliverables tab on the UI for this document type
SHOW_IN_WORKBENCH_FLAG	VARCHAR2	(1)		Display in Deliverables Workbench?
DOC_VERSION_VIEW	VARCHAR2	(90)		View name for the document versions
ENABLE_ATTACHMENTS_YN	VARCHAR2	(1)	Yes	Indicator to display/hide Show Contract Attachments button on while document authoring
APPLICATION_ID	NUMBER		Yes	Application to which this document type belogs to
EXTERNAL_USERLIST_PROC	VARCHAR2	(90)		Holds the package.procedure name for getting external user list to send notifications for deliverables
SHOW_IN_LOV_YN	VARCHAR2	(1)		identifier to show in lov or not
SHOW_PREVIEW_BTN_YN	VARCHAR2	(1)		Identifier to display or hide Preview Contract button on contract terms
TARGET_RESPONSE_DOC_TYPE	VARCHAR2	(30)		Stores target document type for a given document. For example, Bid is a
DISABLE_AMEND_YN	VARCHAR2	(1)		Identifier to disable all amendment actions in contract terms UI.
START_DATE	DATE			Document Type effective date
END_DATE	DATE			Document Type end date
SHOW_AUTH_PARTY_FLAG	VARCHAR2	(1)		Indicator to show/hide authoring party during contract authoring
ENABLE_ATTACHED_DOC_FLAG	VARCHAR2	(1)		Flag to indicate if the contract can be represented as attached document during contract authoring
VARIABLE_RESOLUTION_AM	VARCHAR2	(255)		Application Module to resolve the system variables
MULTIPARTIES_ALLOWED_FLAG	VARCHAR2	(1)		Flag to indicate whether the Business Document Type Supports Multiparties.
ENABLE_CONTRACT_TERMS_YN	VARCHAR2	(1)
LAYOUT_TEMPLATE_ID	NUMBER
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SIGNATURE_WORKFLOW_NAME	VARCHAR2	(255)
HEADER_TOKEN	VARCHAR2	(30)
DELIVERABLE_TOKEN	VARCHAR2	(30)
ENABLE_NOTES_YN	VARCHAR2	(1)
ENABLE_RISKS_YN	VARCHAR2	(1)
ENABLE_CONTROLS_YN	VARCHAR2	(1)
UI_PERS_FUNCTION	VARCHAR2	(30)
ALLOW_APPROVER_EDIT_YN	VARCHAR2	(1)
APPROVAL_WORKFLOW_NAME	VARCHAR2	(255)
ENABLE_RELATIONSHIPS_YN	VARCHAR2	(1)
ENABLE_PARTIES_YN	VARCHAR2	(1)
AUTO_NUM_ENABLED_YN	VARCHAR2	(1)

Query Text

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


SELECT 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
,      ENABLE_CONTRACT_TERMS_YN
,      LAYOUT_TEMPLATE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SIGNATURE_WORKFLOW_NAME
,      HEADER_TOKEN
,      DELIVERABLE_TOKEN
,      ENABLE_NOTES_YN
,      ENABLE_RISKS_YN
,      ENABLE_CONTROLS_YN
,      UI_PERS_FUNCTION
,      ALLOW_APPROVER_EDIT_YN
,      APPROVAL_WORKFLOW_NAME
,      ENABLE_RELATIONSHIPS_YN
,      ENABLE_PARTIES_YN
,      AUTO_NUM_ENABLED_YN
FROM APPS.OKC_BUS_DOC_TYPES_VL;

Dependencies

[top of page]

APPS.OKC_BUS_DOC_TYPES_VL references the following:

APPS: OKC_BUS_DOC_TYPES_B; OKC_BUS_DOC_TYPES_TL

APPS.OKC_BUS_DOC_TYPES_VL is referenced by following:

APPS: OKC_ALLOWED_TMPL_USAGES_PVT - show dependent code; OKC_CDRL_PVT - show dependent code; OKC_REP_CLOSEOUT_PVT - show dependent code; OKC_REP_QA_CHECK_PVT - show dependent code; OKC_REP_SEARCH_UTIL_PVT - show dependent code; OKC_TERMS_MIGRATE_GRP - show dependent code; OKC_XPRT_REP_INT_PVT - show dependent code