View: FII_PARTY_MKT_CLASS_V

Product:	FII - Financial Intelligence
Description:	This view contains information about the Customer Classification.
Implementation/DBA Data:	APPS.FII_PARTY_MKT_CLASS_V

View Text

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

Columns