ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 22F9F98653208733E06362FB09059E54 select x.* from ( select * from (SELECT 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, VALIDATION_STATUS, VALIDATION_STATUS_CODE, INVOICE_AMOUNT, INV_CURRENCY, INV_CURRENCY_CODE, INVOICE_DATE, PO_NUMBERS, BUYER, VOUCHER_NUM, SOURCE, BASE_AMOUNT, PAYMENT_TERM, GL_DATE, EXCHANGE_RATE, DUE_DATE, PAYMENT_STATUS_FLAG, PAYMENT_STATUS, AMOUNT_REMAINING, AMOUNT_REMAINING_BASE, INSTALLMENT, SUPPLIER_TYPE, SUPPLIER_TYPE_CODE, VENDOR_ID, SUPPLIER_NAME, SUPPLIER_NUMBER, SITE_CODE, LEDGER_ID, LEDGER, GL_CURRENCY, GL_CURRENCY_CODE, LANGUAGE FROM AP_ECC_PREPAYMENT_V WHERE VALIDATION_STATUS_CODE = 'AVAILABLE' and language in ('US')) PIVOT (max(OPERATING_UNIT) as OPERATING_UNIT ,max(VALIDATION_STATUS) as VALIDATION_STATUS, max(INVOICE_TYPE) as INVOICE_TYPE,max(PAYMENT_STATUS) as PAYMENT_STATUS, max(SUPPLIER_TYPE) as SUPPLIER_TYPE, max(PAYMENT_TERM) as PAYMENT_TERM,max (INV_CURRENCY) as INV_CURRENCY, max(GL_CURRENCY) as GL_CURRENCY for LANGUAGE in ('US' "US")) ) x where 2=2 Y AR ECC المدفوعات, الأقساط, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues D ECC Kreditoren, Ratenzahlungen, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues E ECC Payables, Plazos, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues F ECC Payables, Versements, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues I ECC Payables, Rate, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues JA ECC Payables, 賦払, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues KO ECC AP, 할부, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues RU ECC Кредиторы, Выплаты, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues S ECC Lev.reskontra, Delbetalningar, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues TR ECC Borçlar Muhasebesi, Taksitler, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues US ECC Payables, Installments, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues ZHS ECC Payables, 分期付款, SQL2 (1) Imported from Enterprise Command Center Dataset Key: ap-trx Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues Enterprise Command Center 2=2