VIEW: APPS.IEX_LOOKUPS_V

Source

View Text - Preformatted

SELECT fndlkpv.Lookup_Type , fndlkpv.Lookup_Code , fndlkpv.Last_update_date , fndlkpv.last_updated_by , fndlkpv.last_update_login , fndlkpv.creation_date , fndlkpv.created_by , fndlkpv.Meaning , fndlkpv.Enabled_flag , fndlkpv.description , fndlkpv.attribute_category , fndlkpv.attribute1 , fndlkpv.attribute2 , fndlkpv.attribute3 , fndlkpv.attribute4 , fndlkpv.attribute5 , fndlkpv.attribute6 , fndlkpv.attribute7 , fndlkpv.attribute8 , fndlkpv.attribute9 , fndlkpv.attribute10 , fndlkpv.attribute11 , fndlkpv.attribute12 , fndlkpv.attribute13 , fndlkpv.attribute14 , fndlkpv.attribute15 FROM FND_LOOKUP_VALUES fndlkpv WHERE FNDLKPV.LANGUAGE = userenv('LANG') AND FNDLKPV.VIEW_APPLICATION_ID = 695 AND FNDLKPV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(FNDLKPV.LOOKUP_TYPE, FNDLKPV.VIEW_APPLICATION_ID) AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE, sysdate - 1) <= sysdate AND NVL(END_DATE_ACTIVE, sysdate + 1) >= sysdate

View Text - HTML Formatted

SELECT FNDLKPV.LOOKUP_TYPE
, FNDLKPV.LOOKUP_CODE
, FNDLKPV.LAST_UPDATE_DATE
, FNDLKPV.LAST_UPDATED_BY
, FNDLKPV.LAST_UPDATE_LOGIN
, FNDLKPV.CREATION_DATE
, FNDLKPV.CREATED_BY
, FNDLKPV.MEANING
, FNDLKPV.ENABLED_FLAG
, FNDLKPV.DESCRIPTION
, FNDLKPV.ATTRIBUTE_CATEGORY
, FNDLKPV.ATTRIBUTE1
, FNDLKPV.ATTRIBUTE2
, FNDLKPV.ATTRIBUTE3
, FNDLKPV.ATTRIBUTE4
, FNDLKPV.ATTRIBUTE5
, FNDLKPV.ATTRIBUTE6
, FNDLKPV.ATTRIBUTE7
, FNDLKPV.ATTRIBUTE8
, FNDLKPV.ATTRIBUTE9
, FNDLKPV.ATTRIBUTE10
, FNDLKPV.ATTRIBUTE11
, FNDLKPV.ATTRIBUTE12
, FNDLKPV.ATTRIBUTE13
, FNDLKPV.ATTRIBUTE14
, FNDLKPV.ATTRIBUTE15
FROM FND_LOOKUP_VALUES FNDLKPV
WHERE FNDLKPV.LANGUAGE = USERENV('LANG')
AND FNDLKPV.VIEW_APPLICATION_ID = 695
AND FNDLKPV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FNDLKPV.LOOKUP_TYPE
, FNDLKPV.VIEW_APPLICATION_ID)
AND ENABLED_FLAG = 'Y'
AND NVL(START_DATE_ACTIVE
, SYSDATE - 1) <= SYSDATE
AND NVL(END_DATE_ACTIVE
, SYSDATE + 1) >= SYSDATE