ECC Payables, Payments

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Attribute Category, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, Attribute6, Attribute7, Attribute8 ...
Imported from Enterprise Command Center
Dataset Key: ap-paid
Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
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
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV