Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AGING_BUCKET_LINES_UV |
SELECT BKTB.ROWID ROW_ID
, BKTB.ID ID
, BKTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BKTB.IBC_ID IBC_ID
, BKTB.VERSION VERSION
, BKTB.START_DATE START_DATE
, BKTB.END_DATE END_DATE
, BKTB.COMMENTS COMMENTS
, BKTB.LOSS_RATE LOSS_RATE
, BKTB.PROGRAM_ID PROGRAM_ID
, BKTB.REQUEST_ID REQUEST_ID
, BKTB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, BKTB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BKTB.CREATED_BY CREATED_BY
, BKTB.CREATION_DATE CREATION_DATE
, BKTB.LAST_UPDATED_BY LAST_UPDATED_BY
, BKTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BKTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AR.AGING_BUCKET_ID
, AR.AGING_BUCKET_LINE_ID
, AR.BUCKET_SEQUENCE_NUM
, AR.DAYS_START
, AR.DAYS_TO
FROM OKL_BUCKETS BKTB
, AR_AGING_BUCKET_LINES AR
WHERE AR.AGING_BUCKET_LINE_ID = BKTB.IBC_ID(+)