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


VIEW: APPS.OKC_LAUNCH_KGRID_V

Object Details
Object Name: OKC_LAUNCH_KGRID_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_LAUNCH_KGRID_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
ROW_ID ROWID (10)
The address of the row in the database
PARENT_GROUP_ID NUMBER

Foreign Key to Groups indicating Parent of Group
CONTRACT_ID NUMBER

Contract primary key.
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
STATUS_CODE VARCHAR2 (30)
Contract Status Code
STATUS_MEANING VARCHAR2 (90)
Contract Status Meaning
SUBCLASS_CODE VARCHAR2 (30)
Contract Subclass Code
SUBCLASS_MEANING VARCHAR2 (90)
Contract Subclass Meaning
QCL_ID NUMBER

Foreign key to OKC_QA_CHECK_LISTS_B.
CONTRACT_NUMBER VARCHAR2 (120)
Contract (RFP,Proposal etc.) Legal Identifier.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
A unique internal name for the contract number.
CONTRACT_AMOUNT NUMBER

Estimated amount of contract.
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CUST_PO_NUMBER_REQ_YN VARCHAR2 (3)
Purchase Order required flag.
PRE_PAY_REQ_YN VARCHAR2 (3)
Contract pre-payment required flag.
CUST_PO_NUMBER VARCHAR2 (150)
Customer's Purchase Order Number.
SHORT_DESCRIPTION VARCHAR2 (600)
User entered free format abbreviated text description.
COMMENTS VARCHAR2 (1995)
User entered comment.
DESCRIPTION VARCHAR2 (1995)
User entered free format text description.
DPAS_RATING VARCHAR2 (24)
DPAS rating.
KNOWN_AS VARCHAR2 (300)
Another name for the contract similar to cognomen
TEMPLATE_YN VARCHAR2 (3)
Yes or No Flag.
TEMPLATE_USED VARCHAR2 (120)
Yes or No Flag.
DATE_APPROVED DATE

Date contract was approved.
DATETIME_CANCELLED DATE

Date / Time Contract was cancelled.
AUTO_RENEW_DAYS NUMBER (4)
Number of days before automatic renewal of contract.
DATE_SIGNED DATE

Date contract was signed.
DATE_TERMINATED DATE

Date contract terminated.
DATE_RENEWED DATE

Date contract was renewed.
TRN_CODE VARCHAR2 (30)
Termination code.
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.
AUTHORING_ORG_ID NUMBER

Authoring Organization ID.
APPLICATION_ID NUMBER

Application Identifier
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
ORG_ID NUMBER

OPERATING_UNIT VARCHAR2 (240)
Query Text

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


SELECT ROW_ID
,      PARENT_GROUP_ID
,      CONTRACT_ID
,      OBJECT_VERSION_NUMBER
,      STATUS_CODE
,      STATUS_MEANING
,      SUBCLASS_CODE
,      SUBCLASS_MEANING
,      QCL_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      CONTRACT_AMOUNT
,      CURRENCY_CODE
,      CUST_PO_NUMBER_REQ_YN
,      PRE_PAY_REQ_YN
,      CUST_PO_NUMBER
,      SHORT_DESCRIPTION
,      COMMENTS
,      DESCRIPTION
,      DPAS_RATING
,      KNOWN_AS
,      TEMPLATE_YN
,      TEMPLATE_USED
,      DATE_APPROVED
,      DATETIME_CANCELLED
,      AUTO_RENEW_DAYS
,      DATE_SIGNED
,      DATE_TERMINATED
,      DATE_RENEWED
,      TRN_CODE
,      START_DATE
,      END_DATE
,      AUTHORING_ORG_ID
,      APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      OPERATING_UNIT
FROM APPS.OKC_LAUNCH_KGRID_V;

Dependencies

[top of page]

APPS.OKC_LAUNCH_KGRID_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymJTF_RS_GROUPS_DENORM
SynonymJTF_RS_GROUP_MEMBERS
SynonymJTF_RS_RESOURCE_EXTNS
SynonymJTF_RS_ROLES_B
SynonymJTF_RS_ROLE_RELATIONS
SynonymOKC_APP_FUNCTION_ACCESSES
SynonymOKC_K_ACCESSES
SynonymOKC_K_GRPINGS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_TL
SynonymOKC_STATUSES_TL
SynonymOKC_SUBCLASSES_TL
SynonymOKC_SUBCLASS_RESPS

APPS.OKC_LAUNCH_KGRID_V is not referenced by any database object