VIEW: APPS.OKL_BUCKET_NAME_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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