PJS_LOOKUPS

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name

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

Query

SQL_Statement

SELECT vl.view_application_id, vl.set_id, vl.lookup_type, vl.lookup_code, vl.meaning, vl.description, vl.display_sequence, vl.enabled_flag, vl.tag, vl.start_date_active, vl.end_date_active, vl.created_by, vl.creation_date, vl.last_updated_by, vl.last_update_login, vl.last_update_date, vl.attribute_category, vl.attribute1, vl.attribute2, vl.attribute3, vl.attribute4, vl.attribute5, vl.attribute6, vl.attribute7, vl.attribute8, vl.attribute9, vl.attribute10, vl.attribute11, vl.attribute12, vl.attribute13, vl.attribute14, vl.attribute15 FROM fnd_lookup_values_vl vl, fnd_lookup_types types WHERE types.module_id = '61ECAF4AAABEE990E040449821C61C97' and vl.set_id = 0 and types.view_application_id= 0 and types.lookup_type = vl.lookup_type