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

VIEW: APPS.OKC_KSRCH_REPORT_V

Object Details
Object Name: OKC_KSRCH_REPORT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_KSRCH_REPORT_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract (RFP,Proposal etc.) Legal Identifier.
MODIFIER VARCHAR2 (120)
VERSION VARCHAR2 (81)
CATEGORY VARCHAR2 (90) Yes Short meaning associated with code value.
DESCRIPTION VARCHAR2 (1995)
User entered free format text description.
START_DATE DATE

The beginning of the active period, one second after midnight on the date indicated.
END_DATE DATE

The end of the active period, one second before midnight on the date indicated.
STATUS VARCHAR2 (90) Yes Short meaning associated with code value.
APPROVED DATE

Date contract was approved.
SIGNED DATE

Date contract was signed.
TERMINATED DATE

Date contract terminated.
RENEWED DATE

Date contract was renewed.
CANCELLED DATE

Date / Time Contract was cancelled.
CURRENCY VARCHAR2 (15)
Currency code.
AMOUNT NUMBER

Estimated amount of contract.
KNOWN_AS VARCHAR2 (300)
Cognomen field.
REPORT_ID NUMBER

This column is intended to store the report run number. Incremented for every search report made from the contracts search form.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
Query Text

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


SELECT CONTRACT_NUMBER
,      MODIFIER
,      VERSION
,      CATEGORY
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      STATUS
,      APPROVED
,      SIGNED
,      TERMINATED
,      RENEWED
,      CANCELLED
,      CURRENCY
,      AMOUNT
,      KNOWN_AS
,      REPORT_ID
,      LAST_UPDATE_DATE
FROM APPS.OKC_KSRCH_REPORT_V;

Dependencies

[top of page]

APPS.OKC_KSRCH_REPORT_V references the following:

SchemaAPPS
SynonymOKC_KEXP_REPORT
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_TL
SynonymOKC_K_VERS_NUMBERS
SynonymOKC_STATUSES_TL
SynonymOKC_SUBCLASSES_TL

APPS.OKC_KSRCH_REPORT_V is not referenced by any database object