AP_TERMS_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name
ATTRIBUTE1 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE_CATEGORY CREATED_BY CREATION_DATE DESCRIPTION DUE_CUTOFF_DAY ENABLED_FLAG END_DATE_ACTIVE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME RANK START_DATE_ACTIVE TERM_ID TYPE

Query

SQL_Statement

SELECT AT.ATTRIBUTE1 ATTRIBUTE1 , AT.ATTRIBUTE10 ATTRIBUTE10 , AT.ATTRIBUTE11 ATTRIBUTE11 , AT.ATTRIBUTE12 ATTRIBUTE12 , AT.ATTRIBUTE13 ATTRIBUTE13 , AT.ATTRIBUTE14 ATTRIBUTE14 , AT.ATTRIBUTE15 ATTRIBUTE15 , AT.ATTRIBUTE2 ATTRIBUTE2 , AT.ATTRIBUTE3 ATTRIBUTE3 , AT.ATTRIBUTE4 ATTRIBUTE4 , AT.ATTRIBUTE5 ATTRIBUTE5 , AT.ATTRIBUTE6 ATTRIBUTE6 , AT.ATTRIBUTE7 ATTRIBUTE7 , AT.ATTRIBUTE8 ATTRIBUTE8 , AT.ATTRIBUTE9 ATTRIBUTE9 , AT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , AT.CREATED_BY CREATED_BY , AT.CREATION_DATE CREATION_DATE , ATT.DESCRIPTION DESCRIPTION , AT.DUE_CUTOFF_DAY DUE_CUTOFF_DAY , AT.ENABLED_FLAG ENABLED_FLAG , AT.END_DATE_ACTIVE END_DATE_ACTIVE , AT.LAST_UPDATED_BY LAST_UPDATED_BY , AT.LAST_UPDATE_DATE LAST_UPDATE_DATE , AT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ATT.NAME NAME , AT.RANK RANK , AT.START_DATE_ACTIVE START_DATE_ACTIVE , AT.TERM_ID TERM_ID , AT.TYPE TYPE FROM AP_TERMS_B AT, AP_TERMS_TL ATT WHERE AT.TERM_ID = ATT.TERM_ID AND ATT.LANGUAGE = USERENV('LANG')