DBA Data[Home] [Help]

VIEW: APPS.FII_PORTAL_POA_SUMMARY_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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