VIEW: APPS.FII_PARTY_MKT_CLASS_V

Source

View Text - Preformatted

SELECT bis_common_parameters.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY, lookup_code CLASS_CODE, meaning CLASS FROM ar_lookups WHERE lookup_type =bis_common_parameters.GET_BIS_CUST_CLASS_TYPE UNION ALL SELECT bis_common_parameters.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY , '-1' CLASS_CODE, message_text CLASS 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 BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY
, LOOKUP_CODE CLASS_CODE
, MEANING CLASS
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE =BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE UNION ALL SELECT BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY
, '-1' CLASS_CODE
, MESSAGE_TEXT CLASS
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