ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4ABA6AD8E05362FB09051F8B select x.* from ( select * from ( SELECT RECORD_TYPE, ECC_SPEC_ID, RECORD_IDENTIFIER, PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, BUDGET_VERSION_ID, BUDGET_TYPE_CODE, BUDGET_TYPE, PERIODICITY, BC_COMMITMENT_EI_ID, FC_START_DATE, FC_END_DATE, TASK_ID, TASK_NUMBER, TASK_NAME, TOP_TASK_ID, SUPPLIER_NAME, SUPPLIER_ID, SUPPLIER_NUMBER, JE_SOURCE_NAME, JE_CATEGORY_NAME, DOCUMENT_TYPE_CODE, DOCUMENT_TYPE_DESC, DOCUMENT_NUMBER, LINE_NUMBER, DISTRIBUTION_NUMBER, PA_DATE, GL_DATE, RESOURCE_LIST_MEMBER_ID, BUDGET_CCID, TXN_CCID, BC_PACKET_ID, PARENT_BC_PACKET_ID, BUD_RESOURCE_LIST_MEMBER_ID, BUD_TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, EXPENDITURE_ITEM_DATE, PA_PERIOD_NAME, GL_PERIOD_NAME, DOCUMENT_HEADER_ID, DOCUMENT_DISTRIBUTION_ID, DOCUMENT_LINE_ID, ENTERED_DR, ENTERED_CR, TXN_CURRENCY, ACCOUNTED_DR, ACCOUNTED_CR, NET_AMOUNT, REJ_ENTERED_DR, REJ_ENTERED_CR, REJ_ACCOUNTED_DR, REJ_ACCOUNTED_CR, REJ_NET_AMOUNT, FUNDS_PROCESS_MODE, STATUS_CODE, STATUS_CODE_DESC, RESULT_CODE, ALERT_TYPE, ALERT_TEXT, RAW_COST, BURDEN_COST, FUNC_CURRENCY, PROJECT_CURRENCY, PROJECT_RATE_TYPE, PROJECT_RATE_DATE, PROJFUNC_CURRENCY_CODE, PROJFUNC_COST_RATE_DATE, PROJFUNC_COST_RATE_TYPE, EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ORGANIZATION, PARENT_DOC_HEADER_ID, PARENT_DOC_LINE_ID, PARENT_DOC_DIST_ID, PARENT_DOC_TYPE_CODE, PARENT_DOC_TYPE_DESC, PARENT_DOC_NUMBER, PARENT_LINE_NUMBER, PARENT_DIST_NUMBER, COST_DISTRIBUTED_FLAG, ACCOUNTING_STATUS, QUANTITY, UNIT_OF_MEASURE, RAW_COST_RATE, DEBIT_ACCOUNT, CREDIT_ACCOUNT, project_id || task_id || GL_PERIOD_NAME ASSC_ID, LANGUAGE FROM PA_ECC_COST_BC_RESULTS where language in ('US'))PIVOT ( max(DOCUMENT_TYPE_DESC) as DOCUMENT_TYPE_DESC, max(EXPENDITURE_ORGANIZATION) as EXPENDITURE_ORGANIZATION, max(STATUS_CODE_DESC) as STATUS_CODE_DESC, max(ALERT_TEXT) as ALERT_TEXT, max(PARENT_DOC_TYPE_DESC) as PARENT_DOC_TYPE_DESC, max(COST_DISTRIBUTED_FLAG) as COST_DISTRIBUTED_FLAG, max(ACCOUNTING_STATUS) as ACCOUNTING_STATUS, max(UNIT_OF_MEASURE) as UNIT_OF_MEASURE for LANGUAGE in ('US' "US")) ) x where 2=2 Y AR ECC المشروعات, تحديد تكلفة المشروعات: نتائج الموازنة Imported from Enterprise Command Center Description: نتائج موازنة المشروع الممكَّنة لمراقبة الموازنة Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues D ECC Projects, Projektkosten: Budgetergebnisse Imported from Enterprise Command Center Description: Für Budgetkontrolle aktivierte Projektbudgetergebnisse Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues E ECC Projects, Costes Proyectos: Resultados Presupuestarios Imported from Enterprise Command Center Description: Resultados en proyectos con control presupuestario activado Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues F ECC Projects, Projects Costing : Résultats des budgets Imported from Enterprise Command Center Description: Résultats des budgets des projets pour contrôle budgétaire activé Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues I ECC Projects, Determinaz. costi progetti: risultati budget Imported from Enterprise Command Center Description: Risultati budget progetto con controllo budgetario abilitato Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues JA ECC Projects, プロジェクト原価計算: 予算結果 Imported from Enterprise Command Center Description: 予算管理対応プロジェクト予算結果 Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues KO ECC 프로젝트, 프로젝트 원가 계산: 예산 결과 Imported from Enterprise Command Center Description: 예산 통제 사용 프로젝트 예산 결과 Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues RU ECC Проекты, Projects Costing: результаты для бюджета Imported from Enterprise Command Center Description: Результаты использ. бюджета для проекта с контр. исполн. бюджета Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues S ECC Projekt, Projektuppföljning: Budgetresultat Imported from Enterprise Command Center Description: Budgetresultat för projekt aktiverat för budgetstyrning Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues TR ECC Projeler, Proje Maliyetlendirme: Bütçe Sonuçları Imported from Enterprise Command Center Description: Bütçe Kontrolü Etkin Proje Bütçesi Sonuçları Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues US ECC Projects, Projects Costing: Budget Results Imported from Enterprise Command Center Description: Budgetary Control-Enabled Project Budget Results Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues ZHS ECC Projects, 项目成本计算：预算结果 Imported from Enterprise Command Center Description: 启用预算控制的项目预算结果 Dataset Key: pa-ds-cost-bcresults Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCRESULTS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues Enterprise Command Center