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