View: FV_FACTS_CUSTOMERS_V

Product:	FV - Federal Financials
Description:	Identifies the eliminations department for customers for FACTS I process
Implementation/DBA Data:	APPS.FV_FACTS_CUSTOMERS_V

View Text

SELECT C.CUST_ACCOUNT_ID CUSTOMER_ID
, DECODE(FAS.FACTSI_CUSTOMER_ATTRIBUTE
, 'ATTRIBUTE1'
, C.ATTRIBUTE1
, 'ATTRIBUTE2'
, C.ATTRIBUTE2
, 'ATTRIBUTE3'
, C.ATTRIBUTE3
, 'ATTRIBUTE4'
, C.ATTRIBUTE4
, 'ATTRIBUTE5'
, C.ATTRIBUTE5
, 'ATTRIBUTE6'
, C.ATTRIBUTE6
, 'ATTRIBUTE7'
, C.ATTRIBUTE7
, 'ATTRIBUTE8'
, C.ATTRIBUTE8
, 'ATTRIBUTE9'
, C.ATTRIBUTE9
, 'ATTRIBUTE10'
, C.ATTRIBUTE10
, 'ATTRIBUTE11'
, C.ATTRIBUTE11
, 'ATTRIBUTE12'
, C.ATTRIBUTE12
, 'ATTRIBUTE13'
, C.ATTRIBUTE13
, 'ATTRIBUTE14'
, C.ATTRIBUTE14
, 'ATTRIBUTE15'
, C.ATTRIBUTE15) ELIMINATIONS_ID
FROM HZ_CUST_ACCOUNTS C
, FV_SYSTEM_PARAMETERS FAS

Columns