View: FII_AR_COLLECTORS_V

Product:	FII - Financial Intelligence
Description:	This view is based on table AR_COLLECTORS, It will contain information about the Collectors.
Implementation/DBA Data:	APPS.FII_AR_COLLECTORS_V

View Text

SELECT COLLECTOR_ID
, DESCRIPTION
, EMPLOYEE_ID
, INACTIVE_DATE
, NAME
, STATUS
, TELEPHONE_NUMBER
, ALIAS
FROM AR_COLLECTORS UNION ALL SELECT -1 COLLECTOR_ID
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER') DESCRIPTION
, NULL EMPLOYEE_ID
, NULL INACTIVE_DATE
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER') NAME
, 'A' STATUS
, NULL TELEPHONE_NUMBER
, NULL ALIAS
FROM DUAL

Columns