ECC Payables, Payments
Description
Categories: Enterprise Command Center
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
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 |
|
LOV |