ECC Payables, Payments (1)

select
x.*
from
(
select * from (SELECT /*+ leading(AP_ECC_PAID_HISTORY_V.temp.ip)
cardinality(AP_ECC_PAID_HISTORY_V.temp.ip 10) index(AP_ECC_PAID_HISTORY_V.temp.ip
AP_INVOICE_PAYMENTS_N10) */
 ECC_SPEC_ID ,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
    record_type ,
        OPERATING_UNIT,
    ORG_ID ,
    invoice_id,
    invoice_type_lookup_code,
    invoice_type,
    invoice_number,
    legal_entity,
    invoice_amount ,
    inv_currency,
    INV_CURRENCY_CODE,
    invoice_date,
    VOUCHER_NUM,
    SOURCE,
        INSTALLMENT,
    AMOUNT,
    CHECK_NUMBER,
    CHECK_DATE,
    BANK_ACCOUNT_NAME,
    supplier_type,
    supplier_type_code,
    VENDOR_ID,
    Supplier_Name ,
    supplier_number ,
    site_code,
    Ledger,
    GL_CURRENCY,
    GL_CURRENCY_CODE,
    CREATION_DATE,
    LANGUAGE
from AP_ECC_PAID_HISTORY_V
Where CREATION_DATE > (trunc(sysdate)-7) and language in ('US')) PIVOT ( max(SUPPLIER_TYPE) as SUPPLIER_TYPE,max(OPERATING_UNIT) as OPERATING_UNIT,max(INVOICE_TYPE) as INVOICE_TYPE, max (INV_CURRENCY) as INV_CURRENCY,
max(GL_CURRENCY) as GL_CURRENCY
FOR LANGUAGE in ('US' "US"))
) x
where
2=2