View: OKL_BUCKET_NAME_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BUCKET_NAME_UV

View Text

SELECT DISTINCT B.AGING_BUCKET_ID AGING_BUCKET_ID
, AB.BUCKET_NAME BUCKET_NAME
FROM AR_AGING_BUCKET_LINES_TL T
, AR_AGING_BUCKETS AB
, OKL_BUCKETS BKTB
, AR_AGING_BUCKET_LINES_B B
WHERE B.AGING_BUCKET_LINE_ID = BKTB.IBC_ID(+)
AND B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.AGING_BUCKET_ID = AB.AGING_BUCKET_ID
AND BKTB.LOSS_RATE IS NOT NULL

Columns