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_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

business document types view definition

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique system generated ROWID
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Unique 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
LANGUAGE	VARCHAR2	(12)	Yes	Standard MLS column.
SOURCE_LANG	VARCHAR2	(12)	Yes	Standard MLS column.
INTENT	VARCHAR2	(1)		Intent of the document type. Possible values are Buy and Sell
PROVISION_ALLOWED_YN	VARCHAR2	(1)	Yes	Flag to indicate whether provisions are allowed for this document type
DOCUMENT_TYPE_CLASS	VARCHAR2	(30)	Yes	Document Class to which the document type belongs
DOC_PREVIEW_FUNCTION	VARCHAR2	(30)		Function for contract terms structure page. This function will be used in the terms authoring sub flows to navigate back to structure page
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 display notification header region in deliverable notification.This region will include document specific attributes to provide a context to the notification. Applicable only to Procurement Contracts.
SHOW_EXT_VAR_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether supplier updateable flag is to be shown in the UI or not. Applicable only to Procurement Contracts.
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 indicate whether to display View amendment summary action on the Contract Terms page or not. Possible values are Y and N. Applicable only to Procurement Contracts.
ENABLE_DELIVERABLES_YN	VARCHAR2	(1)	Yes	Flag to indicate whether deliverables functionality should be enabled for this document type or not. Possible values are Y and N
SHOW_IN_WORKBENCH_FLAG	VARCHAR2	(1)		Flag to indicate whether this document type should be displayed on the Deliverable Workbench or not. Possible values are Y and N. Applicable only to Procurement Contracts.
DOC_VERSION_VIEW	VARCHAR2	(90)		Database View name for the document versions. This view will be used to render the version poplist in Manage Contract Documents page
ENABLE_ATTACHMENTS_YN	VARCHAR2	(1)	Yes	Flag to indicate whether to display Manage Contract Documents action in Contract Terms page while authoring or not. Possible values are Y and N
APPLICATION_ID	NUMBER		Yes	Identifier of the product to which this document type belongs.
EXTERNAL_USERLIST_PROC	VARCHAR2	(90)		Name of the package.procedure for retrieving external user list on the document to send notifications in deliverables. Applicable only to Procurement Contracts.
SHOW_IN_LOV_YN	VARCHAR2	(1)		Flag to indicate whether to show this business document type in business document type LOVs on a Template
SHOW_PREVIEW_BTN_YN	VARCHAR2	(1)		Flag to indicate whether to display Preview Contract action on the contract terms page or not. Possible values are Y and N
TARGET_RESPONSE_DOC_TYPE	VARCHAR2	(30)		Stores target document type for a given document. For example, Bid is a response document for Auction. This information is used to drive logic in the Copy flow during response process in Oracle Sourcing.
DISABLE_AMEND_YN	VARCHAR2	(1)		Flag to indicate whether to enable amendments flow for this business document or not. Possible values are Y and N
START_DATE	DATE			Effective Date of Business Document Type.
END_DATE	DATE			Expiration Date of Business Document Type
SHOW_AUTH_PARTY_FLAG	VARCHAR2	(1)		Flag to indicate if the Authoring Party field is relevant to this business document. Default value is `Y`. If set to `N`, the field will be not be displayed in the UI and the value for Authoring Party will be defaulted to `Internal`.
ENABLE_ATTACHED_DOC_FLAG	VARCHAR2	(1)		Flag to indicate if Attached Document based contract terms authoring is allowed for this business document. Default value is Y. If set to N, the Contract Source can not be changed to Attached Document for this business document type.
VARIABLE_RESOLUTION_AM	VARCHAR2	(255)		Application Module Definition. This will be used to instantiate and resolve the system variables
ENABLE_CONTRACT_TERMS_YN	VARCHAR2	(1)
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

Query Text

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


SELECT ROW_ID
,      DOCUMENT_TYPE
,      OBJECT_VERSION_NUMBER
,      NAME
,      LANGUAGE
,      SOURCE_LANG
,      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
,      ENABLE_CONTRACT_TERMS_YN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_BUS_DOC_TYPES_V;

Dependencies

[top of page]

APPS.OKC_BUS_DOC_TYPES_V references the following:

APPS: OKC_BUS_DOC_TYPES_B; OKC_BUS_DOC_TYPES_TL

APPS.OKC_BUS_DOC_TYPES_V is referenced by following:

APPS: OKC_DOC_QA_LIST_PVT - show dependent code; OKC_K_ARTICLES_PVT - show dependent code; OKC_REP_CONTRACT_IMP_PVT - show dependent code; OKC_REP_UTIL_PVT - show dependent code; OKC_TERMS_COPY_PVT - show dependent code; OKC_TERMS_MULTIREC_GRP - show dependent code; OKC_TERMS_QA_PVT - show dependent code; OKC_TERMS_SECTIONS_PVT - show dependent code; OKC_TERMS_UTIL_PVT - show dependent code; PO_EDA_DATATEMPLATE_PKG - show dependent code