[Home] [Help] [Dependency Information]
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 |
MultiLingual view (a language resolved view of the data.)
business document types view definition. This is used for the VO for business document types
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 |
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
FROM APPS.OKC_BUS_DOC_TYPES_VL;
|
|
|