Product: | FV - Federal Financials |
---|---|
Description: | Used for the AR/AP Netting Customer Vendor Cross Reference form that is based on the table FV_CUST_VEND_XREFS |
Implementation/DBA Data: | Not implemented in this database |
SELECT FCV.CUST_VEND_XREF_ID CUST_VEND_XREF_ID
, FCV.CUSTOMER_ID CUSTOMER_ID
, RC.CUSTOMER_NAME CUSTOMER_NAME
, RC.CUSTOMER_NUMBER CUSTOMER_NUMBER
, FCV.VENDOR_ID VENDOR_ID
, PV.VENDOR_NAME VENDOR_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, FCV.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FCV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FCV.LAST_UPDATED_BY LAST_UPDATED_BY
, FCV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FCV.CREATION_DATE CREATION_DATE
, FCV.CREATED_BY CREATED_BY
, FCV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, FCV.ATTRIBUTE1 ATTRIBUTE1
, FCV.ATTRIBUTE2 ATTRIBUTE2
, FCV.ATTRIBUTE3 ATTRIBUTE3
, FCV.ATTRIBUTE4 ATTRIBUTE4
, FCV.ATTRIBUTE5 ATTRIBUTE5
, FCV.ATTRIBUTE6 ATTRIBUTE6
, FCV.ATTRIBUTE7 ATTRIBUTE7
, FCV.ATTRIBUTE8 ATTRIBUTE8
, FCV.ATTRIBUTE9 ATTRIBUTE9
, FCV.ATTRIBUTE10 ATTRIBUTE10
, FCV.ATTRIBUTE11 ATTRIBUTE11
, FCV.ATTRIBUTE12 ATTRIBUTE12
, FCV.ATTRIBUTE13 ATTRIBUTE13
, FCV.ATTRIBUTE14 ATTRIBUTE14
, FCV.ATTRIBUTE15 ATTRIBUTE15
FROM RA_CUSTOMERS RC
, PO_VENDORS PV
, FV_CUST_VEND_XREFS FCV
WHERE FCV.CUSTOMER_ID = RC.CUSTOMER_ID
AND FCV.VENDOR_ID = PV.VENDOR_ID