[Home] [Help]
View: FII_AR_PASTDUE_REC_SUM_PMV
Product: | FII - Financial Intelligence |
Description: | FII_AR_PASTDUE_REC_SUM_PMV is an Internal view used to support Risk Indicator Portlets |
Implementation/DBA Data: |
APPS.FII_AR_PASTDUE_REC_SUM_PMV
|
View Text
SELECT F.SET_OF_BOOKS_FK_KEY
, F.OPERATING_UNIT_FK_KEY
, F.CUSTOMER_FK_KEY
, F.CUSTOMER_NAME
, DECODE(F.AGE_BUCKET
, 1
, 0
, NVL(F.RECEIVABLE_G
, 0))
, DECODE(F.AGE_BUCKET
, 4
, NVL(F.RECEIVABLE_G
, 0)
, 0)
, DECODE(F.AGE_BUCKET
, 5
, NVL(F.RECEIVABLE_G
, 0)
, 0)
, F.FUNCTIONAL_CURRENCY
, F.INVOICE_CURRENCY
, F.RECEIVABLE_G FROM FII_AR_OPEN_INSTALLMENT_F F
Columns
Name |
SOB_ID |
ORG_ID |
CUSTOMER_ID |
CUSTOMER_NAME |
TOTAL_PASTDUE |
BUCKET1 |
BUCKET2 |
FUNCTIONAL_CURRENCY |
INVOICE_CURRENCY |
TOTAL |