VIEW: APPS.FII_AP_DISC_LOST_DTL_SUMMARY_V

Source

View Text - Preformatted

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,
        sum(invoice_amount) INVOICE_AMOUNT,
        sum(discount_lost) DISCOUNT_lost
FROM    fii_ap_discounts_summary
WHERE   record_type = 'L'
GROUP BY operating_unit_pk_key,
         operating_unit_name,
        trading_partner_pk_key,
        trading_partner_name,
        invoice_unique_identifier,
        invoice_num,
        invoice_date

View Text - HTML Formatted

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
, SUM(INVOICE_AMOUNT) INVOICE_AMOUNT
, SUM(DISCOUNT_LOST) DISCOUNT_LOST FROM FII_AP_DISCOUNTS_SUMMARY WHERE RECORD_TYPE = 'L' GROUP BY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, TRADING_PARTNER_PK_KEY
, TRADING_PARTNER_NAME
, INVOICE_UNIQUE_IDENTIFIER
, INVOICE_NUM
, INVOICE_DATE