View: OKC_LAUNCH_LGRID_V

Product:	OKC - Contracts Core
Description:	View for Launchpad overview tab - contract lines
Implementation/DBA Data:	APPS.OKC_LAUNCH_LGRID_V

View Text

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.CHR_ID CHR_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.STS_CODE STS_CODE
, STS.MEANING STATUS_MEANING
, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, CLEB.TRN_CODE TRN_CODE
, CLEB.LSE_ID
, LSET.NAME LSE_NAME
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLET.COMMENTS COMMENTS
, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED
, CLEB.CURRENCY_CODE
, CLEB.DATE_TERMINATED DATE_TERMINATED
, OKC_QUERY.SETSUBLINEINDENT(CLEB.CHR_ID
, CLEB.ID
, CLET.NAME) NAME
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.PRICE_TYPE PRICE_TYPE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_LINE_STYLES_TL LSET
, OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
, OKC_STATUSES_TL STS
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND LSET.ID = CLEB.LSE_ID
AND LSET.LANGUAGE = CLET.LANGUAGE
AND STS.CODE = CLEB.STS_CODE
AND STS.LANGUAGE = USERENV('LANG')

Columns