FND Design Data [Home] [Help]

View: OKL_AGING_BUCKET_LINES_UV

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.OKL_AGING_BUCKET_LINES_UV
View Text

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(+)

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
IBC_ID
VERSION
START_DATE
END_DATE
COMMENTS
LOSS_RATE
PROGRAM_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
AGING_BUCKET_ID
AGING_BUCKET_LINE_ID
BUCKET_SEQUENCE_NUM
DAYS_START
DAYS_TO