[Home] [Help]
View: FII_AP_OP_IND_PAYMT_SUMMARY_V
Product: | FII - Financial Intelligence (Obsolete) |
Description: | FII_AP_OP_IND_PAYMT_SUMMARY_V is the view to support Payables Payment Summary Drill Downs Portlet |
Implementation/DBA Data: |
Not implemented in this database
|
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_PAYMENT_COUNT INVOICE_PAYMENT_COUNT
, INV_PAYMENT_AMOUNT INVOICE_PAYMENT_AMOUNT
FROM FII_AP_OP_INDICATOR_SUMMARY
WHERE INV_PAYMENT_COUNT > 0
Columns
Name |
OPERATING_UNIT_PK_KEY |
OPERATING_UNIT_NAME |
TRADING_PARTNER_PK_KEY |
TRADING_PARTNER_NAME |
INVOICE_PAYMENT_COUNT |
INVOICE_PAYMENT_AMOUNT |