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