PO_LOOKUP_CODES
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: VIEW
Columns
Name |
---|
LOOKUP_CODE LOOKUP_TYPE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY DISPLAYED_FIELD DESCRIPTION END_DATE_ACTIVE ENABLED_FLAG REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 |
Query
SQL_Statement |
---|
SELECT LV.LOOKUP_CODE, LV.LOOKUP_TYPE, LV.LAST_UPDATE_DATE, LV.LAST_UPDATED_BY, LV.LAST_UPDATE_LOGIN, LV.CREATION_DATE, LV.CREATED_BY, LV.MEANING displayed_field, LV.DESCRIPTION, LV.END_DATE_ACTIVE, LV.ENABLED_FLAG, to_number(NULL) REQUEST_ID, to_number(NULL) PROGRAM_APPLICATION_ID, to_number(NULL) PROGRAM_ID, to_date(NULL) PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 FROM fusion.FND_LOOKUP_VALUES LV , fusion.FND_LOOKUP_TYPES FT WHERE FT.LOOKUP_TYPE = LV.lookup_TYPE and LV.VIEW_APPLICATION_ID = FT.VIEW_APPLICATION_ID and LANGUAGE = USERENV('LANG') AND FT.MODULE_ID in ('47110F64AC6208E2E040449823C60DB6', '61ECAF4AAAC5E990E040449821C61C97') |