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,
invoice_pk_key INVOICE_PK_KEY,
invoice_num INVOICE_NUMBER,
invoice_amount INVOICE_AMOUNT,
sch_payment_id PAYMENT_ID,
open_payment_amount PAYMENT_AMOUNT,
payment_due_date PAYMENT_DUE_DATE
FROM FII_AP_TRANS_BACKLOG_SUMMARY
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
,
INVOICE_PK_KEY INVOICE_PK_KEY
,
INVOICE_NUM INVOICE_NUMBER
,
INVOICE_AMOUNT INVOICE_AMOUNT
,
SCH_PAYMENT_ID PAYMENT_ID
,
OPEN_PAYMENT_AMOUNT PAYMENT_AMOUNT
,
PAYMENT_DUE_DATE PAYMENT_DUE_DATE
FROM FII_AP_TRANS_BACKLOG_SUMMARY
|
|
|