[Home] [Help]
View: FII_AR_DISPUTE_REC_WH_V
Product: | FII - Financial Intelligence |
Description: | FII_AR_DISPUTE_REC_WH_V is an Internal view used to support Risk Indicator Portlets |
Implementation/DBA Data: |
APPS.FII_AR_DISPUTE_REC_WH_V
|
View Text
SELECT F.SET_OF_BOOKS_FK_KEY
, F.OPERATING_UNIT_FK_KEY
, F.CUSTOMER_FK_KEY
, F.CUSTOMER_NAME
, F.INVOICE_NUMBER
, F.DUE_DATE
, F.DISPUTE_DATE
, SYSDATE-F.DUE_DATE
, SYSDATE-F.DISPUTE_DATE
, F.FUNCTIONAL_CURRENCY
, F.INVOICE_CURRENCY
, F.RECEIVABLE_G FROM FII_AR_OPEN_INSTALLMENT_F F
WHERE F.RECEIVABLE_G <> 0 AND F.TYPE = 'I'
Columns
Name |
SOB_ID |
ORG_ID |
CUSTOMER_ID |
CUSTOMER_NAME |
INVOICE_NUMBER |
DUE_DATE |
DISPUTE_DATE |
DAYS_PAST_DUE |
DAYS_IN_DISPUTE |
FUNCTIONAL_CURRENCY |
INVOICE_CURRENCY |
RECEIVABLE_G |