DBA Data[Home] [Help]

VIEW: APPS.BSC_LOOKUPS

Source

View Text - Preformatted

SELECT VIEW_APPLICATION_ID AS APPLICATION_ID, LOOKUP_TYPE, LOOKUP_CODE, MEANING, DESCRIPTION, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE FROM FND_LOOKUP_VALUES LV WHERE LANGUAGE = userenv('LANG') and LV.LOOKUP_TYPE LIKE 'BSC%' and SECURITY_GROUP_ID = 0
   
View Text - HTML Formatted

SELECT VIEW_APPLICATION_ID AS APPLICATION_ID
, LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM FND_LOOKUP_VALUES LV
WHERE LANGUAGE = USERENV('LANG')
AND LV.LOOKUP_TYPE LIKE 'BSC%'
AND SECURITY_GROUP_ID = 0