[Home] [Help]
View: FII_AR_PASTDUE_REC_PMV
Product: | FII - Financial Intelligence (Obsolete) |
Description: | FII_AR_PASTDUE_REC_PMV is an Internal view used to support Risk Indicator Portlets |
Implementation/DBA Data: |
Not implemented in this database
|
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.INSTALLMENT_NUMBER
, F.INVOICE_DATE
, F.DUE_DATE
, TRUNC(SYSDATE
, 'DD')-TRUNC(F.DUE_DATE
, 'DD')
, DECODE(DISPUTE_DATE
, NULL
, 'NO'
, 'YES')
, F.DATE_OF_SNAPSHOT
, F.FUNCTIONAL_CURRENCY
, F.INVOICE_CURRENCY
, F.RECEIVABLE_G FROM FII_AR_OPEN_INSTALLMENT_F F
WHERE F.RECEIVABLE_G <> 0
AND F.AGE_BUCKET <> 1 AND F.TYPE = 'I'
Columns
Name |
SOB_ID |
ORG_ID |
CUSTOMER_ID |
CUSTOMER_NAME |
INVOICE_NUMBER |
INSTALLMENT_NUMBER |
INVOICE_DATE |
DUE_DATE |
DAYS_PAST_DUE |
DISPUTE_FLAG |
DATE_OF_SNAPSHOT |
FUNCTIONAL_CURRENCY |
INVOICE_CURRENCY |
TOTAL |