[Home] [Help]
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
Name |
ORG_ID |
CUSTOMER_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
RECEIVABLE_TYPE_ID |
DESCRIPTION |