View: FII_AR_AGING_WH_V

Product:	FII - Financial Intelligence
Description:	FII_AR_AGING_WH_V is an Internal view used to support Risk Indicator Portlets
Implementation/DBA Data:	APPS.FII_AR_AGING_WH_V

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