VIEW: APPS.FII_PARTNER_MKT_CLASS_V

Source

View Text - Preformatted

SELECT lookup_code id, meaning value from ar_lookups WHERE lookup_type =bis_common_parameters.GET_BIS_CUST_CLASS_TYPE union select to_char('-1') id, message_text value from fnd_new_messages m, fnd_application a where 'EDW_UNASSIGNED' = m.message_name and m.language_code = userenv('LANG') and 'BIS' = a.application_short_name and m.application_id = a.application_id

View Text - HTML Formatted

SELECT LOOKUP_CODE ID
, MEANING VALUE
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE =BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE UNION SELECT TO_CHAR('-1') ID
, MESSAGE_TEXT VALUE
FROM FND_NEW_MESSAGES M
, FND_APPLICATION A
WHERE 'EDW_UNASSIGNED' = M.MESSAGE_NAME
AND M.LANGUAGE_CODE = USERENV('LANG')
AND 'BIS' = A.APPLICATION_SHORT_NAME
AND M.APPLICATION_ID = A.APPLICATION_ID