eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	OKC.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:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; OKC_K_HEADERS_ALL_B; OKC_K_HEADERS_TL; OKC_STATUSES_TL; OKC_SUBCLASSES_TL; OKC_UTIL - show dependent code

APPS.OKC_EBIZ_KHEADERS_V is not referenced by any database object