FND Design Data [Home] [Help]

View: FV_FACTS_VENDORS_V

Product: FV - Federal Financials
Description: Identifies the eliminations department for vendors for FACTS I process
Implementation/DBA Data: ViewAPPS.FV_FACTS_VENDORS_V
View Text

SELECT V.VENDOR_ID
, DECODE(FAS.FACTSI_VENDOR_ATTRIBUTE
, 'ATTRIBUTE1'
, V.ATTRIBUTE1
, 'ATTRIBUTE2'
, V.ATTRIBUTE2
, 'ATTRIBUTE3'
, V.ATTRIBUTE3
, 'ATTRIBUTE4'
, V.ATTRIBUTE4
, 'ATTRIBUTE5'
, V.ATTRIBUTE5
, 'ATTRIBUTE6'
, V.ATTRIBUTE6
, 'ATTRIBUTE7'
, V.ATTRIBUTE7
, 'ATTRIBUTE8'
, V.ATTRIBUTE8
, 'ATTRIBUTE9'
, V.ATTRIBUTE9
, 'ATTRIBUTE10'
, V.ATTRIBUTE10
, 'ATTRIBUTE11'
, V.ATTRIBUTE11
, 'ATTRIBUTE12'
, V.ATTRIBUTE12
, 'ATTRIBUTE13'
, V.ATTRIBUTE13
, 'ATTRIBUTE14'
, V.ATTRIBUTE14
, 'ATTRIBUTE15'
, V.ATTRIBUTE15) ELIMINATIONS_ID
FROM PO_VENDORS V
, FV_SYSTEM_PARAMETERS FAS

Columns

Name
VENDOR_ID
ELIMINATIONS_ID