DBA Data[Home] [Help]

VIEW: APPS.POA_PORTAL_TRSCTN_BACKLOG_V

Source

View Text - Preformatted

SELECT OPERATING_UNIT_PK_KEY,OPERATING_UNIT_NAME, NVL(CNT_LATE_SUPPLIER_CONF,0), NVL(AVG_LATE_SUP_CONF_AGE,0),NVL(LATE_RECEIPTS,0), NVL(LATE_RECEIPTS_AVG_AGE,0), NVL(OPEN_PAYMENTS,0), NVL(OPEN_PAY_AGE,0) FROM POA_PORTAL_FII_SUMMARY
View Text - HTML Formatted

SELECT OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, NVL(CNT_LATE_SUPPLIER_CONF
, 0)
, NVL(AVG_LATE_SUP_CONF_AGE
, 0)
, NVL(LATE_RECEIPTS
, 0)
, NVL(LATE_RECEIPTS_AVG_AGE
, 0)
, NVL(OPEN_PAYMENTS
, 0)
, NVL(OPEN_PAY_AGE
, 0)
FROM POA_PORTAL_FII_SUMMARY