VIEW: APPS.OKL_AGING_BUCKET_LINES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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