DBA Data[Home] [Help]

VIEW: APPS.ISC_RISK_INDICATORS_S

Source

View Text - Preformatted

SELECT operating_unit_fk_key OPER_UNIT_FK_KEY, operating_unit_name OPER_UNIT_NAME, nvl(ship_bklg_amt_g, 0) SHIP_BKLG_AMT_G, nvl(dlqt_bklg_amt_g, 0) DLQT_BKLG_AMT_G, nvl(open_rec_amt_g, 0) OPEN_REC_AMT_G, nvl(pastdue_rec_amt_g, 0) PASTDUE_REC_AMT_G FROM FII_AR_RISK_INDICATOR_F
View Text - HTML Formatted

SELECT OPERATING_UNIT_FK_KEY OPER_UNIT_FK_KEY
, OPERATING_UNIT_NAME OPER_UNIT_NAME
, NVL(SHIP_BKLG_AMT_G
, 0) SHIP_BKLG_AMT_G
, NVL(DLQT_BKLG_AMT_G
, 0) DLQT_BKLG_AMT_G
, NVL(OPEN_REC_AMT_G
, 0) OPEN_REC_AMT_G
, NVL(PASTDUE_REC_AMT_G
, 0) PASTDUE_REC_AMT_G
FROM FII_AR_RISK_INDICATOR_F