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_CONTRACT_DOCS_DETAILS_VL

Object Details

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

View Type

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

This view lists contract attachments belonging to a business document type.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Auto generated by Headstart utilities
BUSINESS_DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Busness document type.
BUSINESS_DOCUMENT_ID	NUMBER		Yes	Business document unique identifier
BUSINESS_DOCUMENT_VERSION	NUMBER		Yes	Busines document version
ATTACHED_DOCUMENT_ID	NUMBER		Yes	FND attached document identifier
EXTERNAL_VISIBILITY_FLAG	VARCHAR2	(1)	Yes	For future use.
EFFECTIVE_FROM_TYPE	VARCHAR2	(30)	Yes	Document type for the reference document.
EFFECTIVE_FROM_ID	NUMBER		Yes	Document Identifier for reference document
EFFECTIVE_FROM_VERSION	NUMBER		Yes	Version from which the document is referenced.
PARENT_ATTACHED_DOC_ID	NUMBER			Document Identifier for the Parent Document.
INCLUDE_FOR_APPROVAL_FLAG	VARCHAR2	(1)	Yes	Indicates whether this document should be included in approval
PRIMARY_CONTRACT_DOC_FLAG	VARCHAR2	(1)		Indicates whether this document is the Primary Contract Document containing the Contract Terms when the Contract Source is set to Attached Document. This document will be used in lieu of structured contract terms.
MERGEABLE_DOC_FLAG	VARCHAR2	(1)		Indicates whether this document is mergeable during preview of business document.
GENERATED_FLAG	VARCHAR2	(1)		Indicates whether this document is auto generated.
DELETE_FLAG	VARCHAR2	(1)		Indicates whether this document is deleted.
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.
CREATED_BY	NUMBER	(15)	Yes	Standard who colum.
CREATION_DATE	DATE		Yes	Standard who colum.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who colum.
LAST_UPDATE_DATE	DATE		Yes	Standard who colum.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who colum.
PROGRAM_ID	NUMBER			Standard who colum.
PROGRAM_APPLICATION_ID	NUMBER			Standard who colum.
REQUEST_ID	NUMBER			Standard who colum.
CATEGORY_ID	NUMBER		Yes	Document category identifier
CATEGORY_CODE	VARCHAR2	(30)	Yes	Document category code
CATEGORY_DESCRIPTION	VARCHAR2	(255)	Yes	Document category description
DOCUMENT_DESCRIPTION	VARCHAR2	(255)		Attached document description
FILE_NAME	VARCHAR2	(4000)		Document file name.
MEDIA_ID	NUMBER			Document media identifier
ENTITY_NAME	VARCHAR2	(40)	Yes	Entity name for the attachment.
PK1_VALUE	VARCHAR2	(100)		Primary key1 value.
PK2_VALUE	VARCHAR2	(100)		Primary key2 value.
PK3_VALUE	VARCHAR2	(100)		Primary key3 value.
PK4_VALUE	VARCHAR2	(150)		Primary key4 value.
PK5_VALUE	VARCHAR2	(150)		Primary key5 value.
DATATYPE_ID	NUMBER		Yes	Document datatype identitfier.
DATATYPE_CODE	VARCHAR2	(80)	Yes	Document datatype code.
UPDATE_SWITCHER	VARCHAR2	(14)		Update switcher column.

Query Text

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


SELECT ROW_ID
,      BUSINESS_DOCUMENT_TYPE
,      BUSINESS_DOCUMENT_ID
,      BUSINESS_DOCUMENT_VERSION
,      ATTACHED_DOCUMENT_ID
,      EXTERNAL_VISIBILITY_FLAG
,      EFFECTIVE_FROM_TYPE
,      EFFECTIVE_FROM_ID
,      EFFECTIVE_FROM_VERSION
,      PARENT_ATTACHED_DOC_ID
,      INCLUDE_FOR_APPROVAL_FLAG
,      PRIMARY_CONTRACT_DOC_FLAG
,      MERGEABLE_DOC_FLAG
,      GENERATED_FLAG
,      DELETE_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      CATEGORY_ID
,      CATEGORY_CODE
,      CATEGORY_DESCRIPTION
,      DOCUMENT_DESCRIPTION
,      FILE_NAME
,      MEDIA_ID
,      ENTITY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      DATATYPE_ID
,      DATATYPE_CODE
,      UPDATE_SWITCHER
FROM APPS.OKC_CONTRACT_DOCS_DETAILS_VL;

Dependencies

[top of page]

APPS.OKC_CONTRACT_DOCS_DETAILS_VL references the following:

APPS: FND_ATTACHED_DOCUMENTS; FND_DOCUMENTS; FND_DOCUMENTS_TL; FND_DOCUMENT_CATEGORIES_TL; FND_DOCUMENT_DATATYPES; OKC_CONTRACT_DOCS

APPS.OKC_CONTRACT_DOCS_DETAILS_VL is referenced by following:

APPS: OKC_REP_SEARCH_UTIL_PVT - show dependent code; OKC_TERMS_DEVIATIONS_PVT - show dependent code; OKC_TERMS_UTIL_GRP - show dependent code