[Home] [Help]
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
Name |
PARTY_ID |
CUST_ACCOUNT_ID |
SITE_USE_ID |
COLLECTOR_ID |