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

VIEW: APPS.OKC_LAUNCH_HISTORY_GRID_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (7)
Indicates the type of history : whether Change Control or Versioning.
CONTRACT_ID NUMBER

Contract primary key.
CONTRACT_NUMBER VARCHAR2 (120)
Contract (RFP,Proposal etc.) Legal Identifier.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
A unique internal name for the contract number.
DESCRIPTION VARCHAR2 (600)
User entered free format text description.
MAJOR_VERSION VARCHAR2 (50)
The version of the contract for this history record.
CREATED_BY NUMBER (15)
Standard Who column.
USER_NAME VARCHAR2 (100)
Name of the User from FND_USERS who created/updated the record.
CREATION_DATE DATE

Standard Who column.
CHANGE_REQUEST_ID NUMBER

Identifier of the Change Request ( NULL in other cases).
NAME VARCHAR2 (150)
Name for the Change Request ( NULL in other cases).
Query Text

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


SELECT TYPE
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      DESCRIPTION
,      MAJOR_VERSION
,      CREATED_BY
,      USER_NAME
,      CREATION_DATE
,      CHANGE_REQUEST_ID
,      NAME
FROM APPS.OKC_LAUNCH_HISTORY_GRID_V;

Dependencies

[top of page]

APPS.OKC_LAUNCH_HISTORY_GRID_V references the following:

SchemaAPPS
SynonymFND_USER
SynonymOKC_CHANGE_REQUESTS_B
SynonymOKC_CHANGE_REQUESTS_TL
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_BH
SynonymOKC_K_HEADERS_TL
SynonymOKC_K_HEADERS_TLH
SynonymOKC_K_VERS_NUMBERS
SynonymOKC_K_VERS_NUMBERS_H

APPS.OKC_LAUNCH_HISTORY_GRID_V is not referenced by any database object