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
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
|
|
|