View: FII_COLLECTORS_BRIDGE_V

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

View Text

SELECT PARTY_ID
, CUST_ACCOUNT_ID
, SITE_USE_ID
, COLLECTOR_ID
FROM FII_COLLECTORS UNION ALL SELECT -2 PARTY_ID
, -2 CUST_ACCOUNT_ID
, -2 SITE_USE_ID
, -1 COLLECTOR_ID
FROM DUAL

Columns