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_unique_identifier INVOICE_PK_KEY,
invoice_num INVOICE_NUMBER,
invoice_date INVOICE_DATE,
record_ID UNIQUE_ID,
invoice_amount INVOICE_AMOUNT,
discount_available DISCOUNT_AVAILABLE,
discount_date DISCOUNT_DATE
FROM fii_ap_discounts_summary
WHERE record_type = 'R'
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_UNIQUE_IDENTIFIER INVOICE_PK_KEY
,
INVOICE_NUM INVOICE_NUMBER
,
INVOICE_DATE INVOICE_DATE
,
RECORD_ID UNIQUE_ID
,
INVOICE_AMOUNT INVOICE_AMOUNT
,
DISCOUNT_AVAILABLE DISCOUNT_AVAILABLE
,
DISCOUNT_DATE DISCOUNT_DATE
FROM FII_AP_DISCOUNTS_SUMMARY
WHERE RECORD_TYPE = 'R'
|
|
|