PSC_LOOKUPS

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name

VIEW_APPLICATION_ID SET_ID LOOKUP_TYPE LOOKUP_CODE MEANING ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE DESCRIPTION DISPLAY_SEQUENCE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 TAG

Query

SQL_Statement

SELECT LV.VIEW_APPLICATION_ID, LV.SET_ID, LV.LOOKUP_TYPE, LV.LOOKUP_CODE, LV.MEANING, LV.ENABLED_FLAG, LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE, LV.DESCRIPTION, LV.DISPLAY_SEQUENCE, LV.LAST_UPDATE_DATE, LV.LAST_UPDATED_BY, LV.LAST_UPDATE_LOGIN, LV.CREATION_DATE, LV.CREATED_BY, 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 FROM FND_LOOKUP_VALUES_VL LV WHERE LV.VIEW_APPLICATION_ID in (10555, 10560, 10554, 10553, 10556, 10552, 10559) AND LV.SET_ID = 0