ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 22F9F986531F8733E06362FB09059E54Y select x.* from ( select * from (select /*+ leading ( trx_v.temp.trx_t trx_v.temp.ai trx_v.temp.ps trx_v.temp.term) use_nl(trx_v.temp.ai trx_v.temp.ps trx_v.temp.pav trx_v.temp.term trx_v.temp.gl) use_nl(trx_v.temp.term trx_v.temp.inv_curr_tl trx_v.temp.gl_curr_tl) full ( trx_v.temp.trx_t ) index ( trx_v.temp.ai ) */ ECC_SPEC_ID, dfv.*, trx_v.ATTRIBUTE_CATEGORY,trx_v.ATTRIBUTE1,trx_v.ATTRIBUTE2,trx_v.ATTRIBUTE3,trx_v. ATTRIBUTE4,trx_v.ATTRIBUTE5,trx_v.ATTRIBUTE6,trx_v.ATTRIBUTE7,trx_v.ATTRIBUTE8,trx_v. ATTRIBUTE9,trx_v.ATTRIBUTE10,trx_v.ATTRIBUTE11,trx_v.ATTRIBUTE12,trx_v.ATTRIBUTE13,trx_v. ATTRIBUTE14,trx_v.ATTRIBUTE15,trx_v.RECORD_TYPE,trx_v.OPERATING_UNIT,trx_v.ORG_ID,trx_v. INVOICE_ID,trx_v.INVOICE_TYPE_LOOKUP_CODE,trx_v.INVOICE_TYPE,trx_v.INVOICE_NUMBER,trx_v.LEGAL_ENTITY,trx_v. VALIDATION_STATUS,trx_v.VALIDATION_STATUS_CODE,trx_v.INVOICE_AMOUNT,trx_v.UNPAID_AMOUNT,trx_v.INV_CURRENCY,trx_v.INV_CURRENCY_CODE,trx_v.INVOICE_DATE,trx_v. PO_NUMBERS,trx_v.BUYER,trx_v.VOUCHER_NUM,trx_v.SOURCE,trx_v.BASE_AMOUNT,trx_v.PAYMENT_TERM,trx_v. GL_DATE,trx_v.EXCHANGE_RATE,trx_v.DUE_DATE,trx_v.PAYMENT_STATUS_FLAG,trx_v.PAYMENT_STATUS,trx_v. AMOUNT_REMAINING,trx_v.AMOUNT_REMAINING_BASE,trx_v.INSTALLMENT,trx_v.FIRST_DISCOUNT_DATE,trx_v.SECOND_DISCOUNT_DATE,trx_v. THIRD_DISCOUNT_DATE,trx_v.DISCOUNT_AMOUNT_AVAILABLE,trx_v.SECOND_DISC_AMT_AVAILABLE,trx_v.THIRD_DISC_AMT_AVAILABLE,trx_v.DISCOUNT_AMOUNT_AVAILABLE_BASE,trx_v. SECOND_DISC_AMT_AVAILABLE_BASE,trx_v.THIRD_DISC_AMT_AVAILABLE_BASE,trx_v.HOLD_TYPE,trx_v.HOLD_NAME,trx_v.HOLD_COUNT,trx_v. SUPPLIER_TYPE,trx_v.VENDOR_ID,trx_v.SUPPLIER_NAME,trx_v.SUPPLIER_NUMBER,trx_v.SITE_CODE,trx_v. LEDGER_ID,trx_v.LEDGER,trx_v.GL_CURRENCY,trx_v.GL_CURRENCY_CODE,trx_v.SUPPLIER_TYPE_CODE, trx_v.LANGUAGE, trx_v.aging_bucket as aging_bucket, trx_v.aging_period_line_id as aging_period_line_id, trx_v.NEXT_DISCOUNT_DATE, trx_v.EARLIEST_OPEN_HOLD_DATE, trx_v.INVOICE_ON_HOLD_FLAG from AP_ECC_INSTALLMENT_V trx_v , (select "ROW_ID" "'AP_ROW_ID'","CONTEXT" "'AP_CONTEXT'",fnd_ecc_dff_util.get_vset_values('AP_INVOICES','BUDGETED_EXPENDITURE',"BUDGETED_EXPENDITURE", NULL ,NULL,200) "'AP_BUDGETED_EXPENDITURE'",to_char("DUMMY_DATE") "'AP_DUMMY_DATE'","CONCATENATED_SEGMENTS" "'AP_CONCATENATED_SEGMENTS'","BUDGETED_EXPENDITURE" "'AP_BUDGETED_EXPENDITURE_EDOC'",fnd_ecc_dff_util.get_vset_segment_value('AP_INVOICES','BUDGETED_EXPENDITURE',"BUDGETED_EXPENDITURE", NULL ,NULL,200) "'AP_BUDGETED_EXPENDITURE_EVAL'" from ( select ROWID "ROW_ID",ATTRIBUTE_CATEGORY "CONTEXT",ATTRIBUTE10 "BUDGETED_EXPENDITURE",ATTRIBUTE11 "DUMMY_DATE",ATTRIBUTE10||'.'||ATTRIBUTE11 "CONCATENATED_SEGMENTS" from AP_INVOICES_ALL )) dfv where language in ('US') AND TRX_V.ROW_ID = DFV."'AP_ROW_ID'"(+) ) 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(HOLD_TYPE) as HOLD_TYPE, max(HOLD_NAME) as HOLD_NAME, 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 AR ECC المدفوعات, الأقساط, SQL1 (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, SQL1 (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, SQL1 (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, SQL1 (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, SQL1 (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, 賦払, SQL1 (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, 할부, SQL1 (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 Кредиторы, Выплаты, SQL1 (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, SQL1 (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, SQL1 (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, SQL1 (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, 分期付款, SQL1 (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