FND Design Data [Home] [Help]

View: FII_PORTAL_POA_SUMMARY_V

Product: FII - Financial Intelligence
Description: FII_PORTAL_POA_SUMMARY_V is the view to support QTD Operations Indicator Portlet
Implementation/DBA Data: ViewAPPS.FII_PORTAL_POA_SUMMARY_V
View Text

SELECT OPERATING_UNIT_PK_KEY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, PO_LINE_COUNT PURCHASE_ORDER_CREATED
, PO_CYCLE_TIME_AVG PO_CYCLE_TIME
, INVOICE_LINES_COUNT PROCUREMENT_INVOICES_CREATED
, PAYMENT_LINES_COUNT PROCUREMENT_PAYMENTS_CREATED
, RECEIPT_LINES_COUNT RECEIPTS_CREATED
FROM POA_PORTAL_FII_SUMMARY

Columns

Name
OPERATING_UNIT_PK_KEY
OPERATING_UNIT_NAME
PURCHASE_ORDER_CREATED
PO_CYCLE_TIME
PROCUREMENT_INVOICES_CREATED
PROCUREMENT_PAYMENTS_CREATED
RECEIPTS_CREATED