VIEW: APPS.DPP_LOOKUPS

Source

View Text - Preformatted

SELECT LV.LOOKUP_TYPE, LV.LOOKUP_CODE, LV.LAST_UPDATE_DATE, LV.LAST_UPDATED_BY, LV.LAST_UPDATE_LOGIN, LV.CREATION_DATE, LV.CREATED_BY, LV.MEANING, LV.ENABLED_FLAG, LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE, LV.DESCRIPTION, 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 LV, FND_LOOKUP_TYPES LT WHERE LT.LOOKUP_TYPE = LV.LOOKUP_TYPE and LT.APPLICATION_ID = 9000 and LV.LANGUAGE = userenv('LANG') and trunc(nvl(LV.start_date_active, SYSDATE)) <= trunc(SYSDATE) and trunc(nvl(LV.end_date_active, SYSDATE)) >= trunc(SYSDATE) and LV.enabled_flag = 'Y' and LV.SECURITY_GROUP_ID = 0

View Text - HTML Formatted

SELECT LV.LOOKUP_TYPE
, LV.LOOKUP_CODE
, LV.LAST_UPDATE_DATE
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_LOGIN
, LV.CREATION_DATE
, LV.CREATED_BY
, LV.MEANING
, LV.ENABLED_FLAG
, LV.START_DATE_ACTIVE
, LV.END_DATE_ACTIVE
, LV.DESCRIPTION
, 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 LV
, FND_LOOKUP_TYPES LT
WHERE LT.LOOKUP_TYPE = LV.LOOKUP_TYPE
AND LT.APPLICATION_ID = 9000
AND LV.LANGUAGE = USERENV('LANG')
AND TRUNC(NVL(LV.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(LV.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)
AND LV.ENABLED_FLAG = 'Y'
AND LV.SECURITY_GROUP_ID = 0