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]

TABLE: OKC.OKC_BUS_DOC_TYPES_B

Object Details

Object Name:	OKC_BUS_DOC_TYPES_B
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_BUS_DOC_TYPES_B
Subobject Name:
Status:	VALID

Stores all business document types and preferences related to those documents. This information is seeded by each product team that integrates with Oracle Contracts to implement Contract authoring.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_BUS_DOC_TYPES_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	DOCUMENT_TYPE
OKC_BUS_DOC_TYPES_B_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	DOCUMENT_TYPE_CLASS

Columns

Name	Datatype	Length	Mandatory	Comments
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.
DOCUMENT_TYPE_CLASS	VARCHAR2	(30)	Yes	Document Class to which the document type belongs. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE = OKC_DOCUMENT_CLASS
PROVISION_ALLOWED_YN	VARCHAR2	(1)	Yes	Flag to indicate whether provisions are allowed for this document type or not. Possible values are Y and N
DOC_PREVIEW_FUNCTION	VARCHAR2	(30)		The FND Form function that points to the page used to launch Contract Preview.
INTENT	VARCHAR2	(1)		Intent of the document type. Possible values are Buy and Sell
DOC_VIEW_DETAILS_FUNCTION	VARCHAR2	(30)		FND Form function used for viewing document details from Manage Deliverables page. This is only used in Procurement Contracts
NOTIFICATION_HEADER_FUNCTION	VARCHAR2	(2000)		FND Form 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. This is only used in Procurement Contracts
CONTRACT_TERMS_FUNCTION	VARCHAR2	(30)		FND Form Function for contract terms structure page. This function will be used in the terms authoring sub flows to navigate back to structure page
SHOW_EXT_VAR_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether supplier updateable flag is to be shown on the UI or not. Possible values are Y and N. This is only used in Procurement Contracts
APPLICATION_ID	NUMBER		Yes	Unique Identifier of the application/product to which the document type belongs.
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. This is only used in Procurement Contracts
ENABLE_DELIVERABLES_YN	VARCHAR2	(1)	Yes	Flag to indicate whether deliverables functionality should be enabled for the document type or not. Possible values are Y and N. This is only used in Procurement Contracts
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. This is only used in 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 enable Contract Documents functionality or not. Possible values are Y and N
EXTERNAL_USERLIST_PROC	VARCHAR2	(90)		Name of the routine for retrieving external user list on the document to send notifications while managing deliverables. This is only used in Procurement Contracts
SHOW_IN_LOV_YN	VARCHAR2	(1)		Flag to indicate whether to show the business document type in business document type LOVs while defining allowable Template Usage. Possible values are Y and N.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
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 during response process in Sourcing.
CREATION_DATE	DATE		Yes	Standard who column
DISABLE_AMEND_YN	VARCHAR2	(1)		Flag to indicate whether to enable amendments feature for the business document or not. Possible values are Y and N
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
START_DATE	DATE			Document Type effective date.
END_DATE	DATE			Document Type end date.
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
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

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
FROM OKC.OKC_BUS_DOC_TYPES_B;

Dependencies

[top of page]

OKC.OKC_BUS_DOC_TYPES_B does not reference any database object

OKC.OKC_BUS_DOC_TYPES_B is referenced by following:

APPS: OKC_BUS_DOC_TYPES_B