View: FV_INV_STATCUST_V

Product:	FV - Federal Financials
Description:	Stores information for invoice status find
Implementation/DBA Data:	APPS.FV_INV_STATCUST_V

View Text

SELECT DISTINCT FISI.ORG_ID
, FISI.CUSTOMER_ID
, FISI.CUSTOMER_NAME
, FISI.CUSTOMER_NUMBER
, FISI.RECEIVABLE_TYPE_ID
, FVC.DESCRIPTION FROM FV_INV_STATUSES_V FISI
, FV_RECEIVABLE_TYPES FVT
, FV_LOOKUP_CODES FVC
WHERE FISI.RECEIVABLE_TYPE_ID = FVT.RECEIVABLE_TYPE_ID AND FVT.RECEIVABLE_TYPE = FVC.LOOKUP_CODE AND FVC.LOOKUP_TYPE = 'RECEIVABLE_TYPE'

Columns