ZCQ_LOOKUPS
Details
-
Schema: FUSION
-
Object owner: ZCQ
-
Object type: VIEW
Columns
Name |
---|
LOOKUP_TYPE LOOKUP_CODE MEANING DESCRIPTION ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE DISPLAY_SEQUENCE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN VIEW_APPLICATION_ID TERRITORY_CODE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 TAG SET_ID |
Query
SQL_Statement |
---|
SELECT LV.LOOKUP_TYPE, LV.LOOKUP_CODE, LV.MEANING, LV.DESCRIPTION, LV.ENABLED_FLAG, LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE, LV.DISPLAY_SEQUENCE, LV.CREATED_BY, LV.CREATION_DATE, LV.LAST_UPDATED_BY, LV.LAST_UPDATE_DATE, LV.LAST_UPDATE_LOGIN, LV.VIEW_APPLICATION_ID, LV.TERRITORY_CODE, LV.ATTRIBUTE_CATEGORY, LV.ATTRIBUTE1, LV.ATTRIBUTE2, LV.ATTRIBUTE3, LV.ATTRIBUTE4, LV.ATTRIBUTE5, LV.ATTRIBUTE6, LV.ATTRIBUTE7, LV.ATTRIBUTE8, LV.ATTRIBUTE9, LV.ATTRIBUTE10, LV.ATTRIBUTE11, LV.ATTRIBUTE12, LV.ATTRIBUTE13, LV.ATTRIBUTE14, LV.ATTRIBUTE15, LV.TAG, LV.SET_ID From FND_LOOKUP_VALUES_VL LV WHERE LV.VIEW_APPLICATION_ID = 0 and SET_ID = 0 |