[Home] [Help]
View: FII_AR_AGING_PMV
Product: | FII - Financial Intelligence |
Description: | FII_AR_AGING_PMV is an Internal view used to support Risk Indicator Portlets |
Implementation/DBA Data: |
APPS.FII_AR_AGING_PMV
|
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 |