ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 35CC26877E648591E06362FB09057DD0Y 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 AR ECC المدفوعات, المدفوعات (1) 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 D ECC Kreditoren, Zahlungen (1) 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 E ECC Payables, Pagos (1) 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 F ECC Payables, Règlements (1) 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 I ECC Payables, Pagamenti (1) 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 JA ECC Payables, 支払 (1) 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 KO ECC AP, 지급 (1) 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 RU ECC Кредиторы, Платежи (1) 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 S ECC Lev.reskontra, Betalningar (1) 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 TR ECC Borçlar Muhasebesi, Ödemeler (1) 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 US ECC Payables, Payments (1) 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 ZHS ECC Payables, 付款 (1) 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 Enterprise Command Center 2=2