AR_AGING_BUCKET_LINES_VL

Details

• Schema: FUSION

• Object owner: IEX

• Object type: VIEW

Columns

Name

ROW_ID AGING_BUCKET_LINE_ID LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE AGING_BUCKET_ID BUCKET_SEQUENCE_NUM DAYS_START DAYS_TO TYPE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REPORT_HEADING1 REPORT_HEADING2 OBJECT_VERSION_NUMBER SET_ID

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.AGING_BUCKET_LINE_ID, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, B.AGING_BUCKET_ID, B.BUCKET_SEQUENCE_NUM, B.DAYS_START, B.DAYS_TO, B.TYPE, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, T.REPORT_HEADING1, T.REPORT_HEADING2, T.OBJECT_VERSION_NUMBER, T.SET_ID from AR_AGING_BUCKET_LINES_TL T, AR_AGING_BUCKET_LINES_B B WHERE B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID and T.LANGUAGE = userenv('LANG')