[Home] [Help]
View: FII_AR_AGING_PMV
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | FII_AR_AGING_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.DATE_OF_SNAPSHOT
, DECODE(F.AGE_BUCKET
, 1
, NVL(F.RECEIVABLE_G
, 0)
, 0)
, DECODE(F.AGE_BUCKET
, 2
, NVL(F.RECEIVABLE_G
, 0)
, 0)
, DECODE(F.AGE_BUCKET
, 3
, NVL(F.RECEIVABLE_G
, 0)
, 0)
, DECODE(F.AGE_BUCKET
, 4
, NVL(F.RECEIVABLE_G
, 0)
, 0)
, DECODE(F.AGE_BUCKET
, 5
, NVL(F.RECEIVABLE_G
, 0)
, 0)
, DECODE(F.AGE_BUCKET
, 1
, 0
, NVL(F.RECEIVABLE_G
, 0))
, NVL(F.UNAPP_RECEIPT_G
, 0)
, (NVL(F.RECEIVABLE_G
, 0) - NVL(F.UNAPP_RECEIPT_G
, 0)) FROM FII_AR_OPEN_INSTALLMENT_F F
Columns
| Name |
| SOB_ID |
| ORG_ID |
| CUSTOMER_ID |
| DATE_OF_SNAPSHOT |
| BUCKET1 |
| BUCKET2 |
| BUCKET3 |
| BUCKET4 |
| BUCKET5 |
| TOTAL_PASTDUE |
| UNAPP_RECEIPT |
| BALANCE |