[Home] [Help] [Dependency Information]
Object Name: | OKC_TEMPLATE_USAGES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_TEMPLATE_USAGES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | |
DOCUMENT_ID | NUMBER | Yes | ||
AUTHORING_PARTY_CODE | VARCHAR2 | (30) | Yes | Indicates which party of the contract was the author of the contract terms. Valid values are INTERNAL, CUSTOMER, SUPPLIER. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=�OKC_AUTHORING_PARTY_TYPES� |
CONTRACT_SOURCE_CODE | VARCHAR2 | (30) | Yes | Indicates the current source of contract terms for the business document. Valid values are STRUCTURED, ATTACHED. Refers to the LOOKUP_CODE in FND_LOOKUPS where LOOKUP_TYPE=�OKC_CONTRACT_SOURCES� |
TEMPLATE_ID | NUMBER | |||
DOC_NUMBERING_SCHEME | NUMBER | |||
DOCUMENT_NUMBER | VARCHAR2 | (150) | ||
ARTICLE_EFFECTIVE_DATE | DATE | |||
CONFIG_HEADER_ID | NUMBER | |||
CONFIG_REVISION_NUMBER | NUMBER | |||
VALID_CONFIG_YN | VARCHAR2 | (1) | ||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_TYPE
, DOCUMENT_ID
, AUTHORING_PARTY_CODE
, CONTRACT_SOURCE_CODE
, TEMPLATE_ID
, DOC_NUMBERING_SCHEME
, DOCUMENT_NUMBER
, ARTICLE_EFFECTIVE_DATE
, CONFIG_HEADER_ID
, CONFIG_REVISION_NUMBER
, VALID_CONFIG_YN
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
FROM APPS.OKC_TEMPLATE_USAGES_V;
|
|
|