VIEW: APPS.OKC_LAUNCH_LGRID_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')