[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: |
APPS.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 |