[Home] [Help]
View: FII_AP_OP_IND_INV_SUMMARY_V
Product: | FII - Financial Intelligence |
Description: | FII_AP_OP_IND_INV_SUMMARY_V is the view to support Payables Invoice Summary Drill Downs Portlet |
Implementation/DBA Data: |
APPS.FII_AP_OP_IND_INV_SUMMARY_V
|
View Text
SELECT OPERATING_UNIT_PK_KEY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, TRADING_PARTNER_PK_KEY TRADING_PARTNER_PK_KEY
, TRADING_PARTNER_NAME TRADING_PARTNER_NAME
, INV_LINES_COUNT INVOICE_LINES_COUNT
, INV_COUNT INVOICE_COUNT
, INV_AMOUNT INVOICE_AMOUNT
FROM FII_AP_OP_INDICATOR_SUMMARY
WHERE INV_LINES_COUNT > 0
Columns
Name |
OPERATING_UNIT_PK_KEY |
OPERATING_UNIT_NAME |
TRADING_PARTNER_PK_KEY |
TRADING_PARTNER_NAME |
INVOICE_LINES_COUNT |
INVOICE_COUNT |
INVOICE_AMOUNT |