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


VIEW: APPS.OKC_EBIZ_KHEADERS_V

Object Details
Object Name: OKC_EBIZ_KHEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_EBIZ_KHEADERS_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
CONTRACT_ID NUMBER
Yes Contract primary key.
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.
STATUS_CODE VARCHAR2 (30) Yes Contract Status Code
STATUS_MEANING VARCHAR2 (90) Yes Contract Status Meaning
SUBCLASS_CODE VARCHAR2 (30) Yes Contract Subclass Code
SUBCLASS_MEANING VARCHAR2 (90) Yes Contract Subclass Meaning
QCL_ID NUMBER

Foreign key to OKC_QA_CHECK_LISTS_B.
CONTRACT_NUMBER VARCHAR2 (120) Yes 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 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
Yes Authoring Organization ID.
USER_ACCESS_LEVEL VARCHAR2 (4000)
Determines the Rights/Permissions to access the contract for the given user.
APPLICATION_ID NUMBER

Application Identifier
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
ORG_ID NUMBER
Yes
OPERATING_UNIT VARCHAR2 (240) Yes
Query Text

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


SELECT ROW_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
,      USER_ACCESS_LEVEL
,      APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      OPERATING_UNIT
FROM APPS.OKC_EBIZ_KHEADERS_V;

Dependencies

[top of page]

APPS.OKC_EBIZ_KHEADERS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymOKC_K_HEADERS_ALL_B
SynonymOKC_K_HEADERS_TL
SynonymOKC_STATUSES_TL
SynonymOKC_SUBCLASSES_TL
PL/SQL PackageOKC_UTIL - show dependent code

APPS.OKC_EBIZ_KHEADERS_V is not referenced by any database object