DBA Data[Home] [Help] [Dependency Information]

VIEW: OKC.OKC_CONTRACT_DOCS#

Object Details
Object Name: OKC_CONTRACT_DOCS#
Object Type: VIEW
Owner: OKC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_DOCUMENT_TYPE VARCHAR2 (30) Yes
BUSINESS_DOCUMENT_ID NUMBER
Yes
BUSINESS_DOCUMENT_VERSION NUMBER
Yes
ATTACHED_DOCUMENT_ID NUMBER
Yes
EXTERNAL_VISIBILITY_FLAG VARCHAR2 (1) Yes
EFFECTIVE_FROM_TYPE VARCHAR2 (30) Yes
EFFECTIVE_FROM_ID NUMBER
Yes
EFFECTIVE_FROM_VERSION NUMBER
Yes
PARENT_ATTACHED_DOC_ID NUMBER

INCLUDE_FOR_APPROVAL_FLAG VARCHAR2 (1) Yes
GENERATED_FLAG VARCHAR2 (1)
DELETE_FLAG VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

REQUEST_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PRIMARY_CONTRACT_DOC_FLAG VARCHAR2 (1)
MERGEABLE_DOC_FLAG VARCHAR2 (1)
Query Text

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


SELECT 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
,      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
,      PROGRAM_UPDATE_DATE
,      PRIMARY_CONTRACT_DOC_FLAG
,      MERGEABLE_DOC_FLAG
FROM OKC.OKC_CONTRACT_DOCS#;

Dependencies

[top of page]

OKC.OKC_CONTRACT_DOCS# references the following:

SchemaOKC
TableOKC_CONTRACT_DOCS
OKC.OKC_CONTRACT_DOCS# is referenced by following:

SchemaAPPS
SynonymOKC_CONTRACT_DOCS