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.OKL_EBIZ_KHEADERS_V

Object Details

Object Name:	OKL_EBIZ_KHEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_EBIZ_KHEADERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Find grid for eBusiness Integration.This grid is shown of Contracts tab in eBusiness,Purpose of this view is to filter out lease contracts,based on subclass_code='LEASE'

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier in the database
CONTRACT_ID	NUMBER		Yes	Primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
STATUS_MEANING	VARCHAR2	(90)	Yes	Contract Status
SUBCLASS_CODE	VARCHAR2	(30)	Yes	Contract''s subclass. Used to identify Type of contract eg LEASE
SUBCLASS_MEANING	VARCHAR2	(90)	Yes	Contract's subclass meaning. Used to identify Type of contract eg LEASE
QCL_ID	NUMBER			ID of QA check list applicable to this contract.
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
OKL_PRODUCT	VARCHAR2	(150)	Yes	Currency Code
PROGRAM_AGREEMENT	VARCHAR2	(600)		Program Agreement
PRIVATE_LABEL	VARCHAR2	(360)		Private Label
SYNDICATABLE_YN	VARCHAR2	(3)		Syndicatable Y/N
ACCEPTED_DATE	DATE			Accepted Date
BOOK_CLASS	VARCHAR2	(80)	Yes	Book Class
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
CUST_PO_NUMBER_REQ_YN	VARCHAR2	(3)		Indicates if a Purchase Order is required.
PRE_PAY_REQ_YN	VARCHAR2	(3)		Indicates if Contract pre-payment required .
CUST_PO_NUMBER	VARCHAR2	(150)		Customer''s Purchase Order Number.
SHORT_DESCRIPTION	VARCHAR2	(600)		Description of Contract
DPAS_RATING	VARCHAR2	(24)		DPAS rating.
KNOWN_AS	VARCHAR2	(300)		Known as
TEMPLATE_YN	VARCHAR2	(3)	Yes	Indicates if this contract is a Template.
TEMPLATE_USED	VARCHAR2	(120)		Denotes if a template was used to create contract.
AUTO_RENEW_DAYS	NUMBER	(4)		Number of days prior to expiration before which the contract is automatically renewed.
DATE_SIGNED	DATE			Date contract was signed.
DATE_TERMINATED	DATE			Date contract terminated.
TRN_CODE	VARCHAR2	(30)		Termination code.
START_DATE	DATE			Start Date
END_DATE	DATE			End Date
AUTHORING_ORG_ID	NUMBER		Yes	Contract Authoring Organization id
USER_ACCESS_LEVEL	VARCHAR2	(4000)		User Access Level
APPLICATION_ID	NUMBER			Identifier of the Oracle application to which the contract belongs. This is same as the application of the class to which the contract belongs
SECURITIZED_CODE	VARCHAR2	(30)
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
DELINQUENCY_STATUS	VARCHAR2	(80)		Delinquency Status
COLLECTIONS_ACTION	VARCHAR2	(30)		Collections Action

Query Text

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


SELECT ROW_ID
,      CONTRACT_ID
,      OBJECT_VERSION_NUMBER
,      STATUS_MEANING
,      SUBCLASS_CODE
,      SUBCLASS_MEANING
,      QCL_ID
,      CONTRACT_NUMBER
,      OKL_PRODUCT
,      PROGRAM_AGREEMENT
,      PRIVATE_LABEL
,      SYNDICATABLE_YN
,      ACCEPTED_DATE
,      BOOK_CLASS
,      CURRENCY_CODE
,      CUST_PO_NUMBER_REQ_YN
,      PRE_PAY_REQ_YN
,      CUST_PO_NUMBER
,      SHORT_DESCRIPTION
,      DPAS_RATING
,      KNOWN_AS
,      TEMPLATE_YN
,      TEMPLATE_USED
,      AUTO_RENEW_DAYS
,      DATE_SIGNED
,      DATE_TERMINATED
,      TRN_CODE
,      START_DATE
,      END_DATE
,      AUTHORING_ORG_ID
,      USER_ACCESS_LEVEL
,      APPLICATION_ID
,      SECURITIZED_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DELINQUENCY_STATUS
,      COLLECTIONS_ACTION
FROM APPS.OKL_EBIZ_KHEADERS_V;

Dependencies

[top of page]

APPS.OKL_EBIZ_KHEADERS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_PARTIES; IEX_CASE_OBJECTS; IEX_LOOKUPS_V; OKC_K_HEADERS_B; OKC_K_HEADERS_TL; OKC_K_PARTY_ROLES_B; OKC_STATUSES_TL; OKC_SUBCLASSES_TL; OKC_UTIL - show dependent code; OKL_CS_LC_CONTRACT_PVT - show dependent code; OKL_K_HEADERS; OKL_K_VENDOR_PROGRAMS_UV; OKL_PRODUCTS

APPS.OKL_EBIZ_KHEADERS_V is not referenced by any database object