View: OKL_LA_HEADERS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface View for getting Oracle Contracts for Lease header information
Implementation/DBA Data:	APPS.OKL_LA_HEADERS_UV

View Text

SELECT CHR.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, STL.MEANING MEANING
, TL.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHR.STS_CODE STS_CODE
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PROG.SHORT_DESCRIPTION PROGRAM_NAME
, KLP.ID PDT_ID
, KLP.NAME PRODUCT_NAME
, KLP.DESCRIPTION PRODUCT_DESCRIPTION
, CHR.ID ID
, CHR.INV_ORGANIZATION_ID INV_ORG_ID
, KHR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKC_K_HEADERS_B CHR
, OKC_STATUSES_TL STL
, OKC_K_HEADERS_TL TL
, OKL_K_HEADERS KHR
, OKL_PRODUCTS KLP
, OKC_K_HEADERS_TL PROG
WHERE TL.ID = CHR.ID
AND STL.CODE = CHR.STS_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND STL.LANGUAGE = USERENV('LANG')
AND KHR.ID = CHR.ID
AND KLP.ID(+) = KHR.PDT_ID
AND PROG.ID(+) = KHR.KHR_ID

Columns