ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4AB96AD8E05362FB09051F8B select x.* from ( select * from (SELECT trx.RECORD_TYPE, trx.ECC_SPEC_ID, trx.PROJECT_ID, trx.PROJECT_NAME, trx.PROJECT_NUMBER, trx.ORG_ID, trx.OPERATING_UNIT, trx.PROJECT_ORGANIZATION, trx.PROJECT_MANAGER, trx.PROJECT_START_DATE, trx.PROJECT_COMPLETION_DATE, trx.PROJECT_TYPE, trx.PROJECT_TYPE_CLASS_CODE, trx.PROJECT_STATUS_CODE, trx.PROJECT_STATUS_NAME, trx.PROJECT_SYSTEM_STATUS_CODE, trx.PROJFUNC_CURRENCY_CODE, trx.TEMPLATE_FLAG, trx.AMOUNT_TYPE || '-' || trx.BOUNDARY_CODE PERIODICITY, trx.BALANCE_TYPE, trx.EXTERNAL_BUDGET_CODE, trx.GL_BUDGET_VERSION_ID, trx.ENCUMBRANCE_TYPE_ID, trx.BDGT_CNTRL_FLAG, trx.AMOUNT_TYPE, trx.BOUNDARY_CODE, trx.FUND_CONTROL_LEVEL_PROJECT, trx.FUND_CONTROL_LEVEL_TASK, trx.FUND_CONTROL_LEVEL_RES_GRP, trx.FUND_CONTROL_LEVEL_RES, trx.PROJECT_CONTROL_LEVEL, trx.TASK_CONTROL_LEVEL, trx.RES_GROUP_CONTROL_LEVEL, trx.RESOURCE_CONTROL_LEVEL, trx.BUDGET_VERSION_ID, trx.BUDGET_TYPE_CODE, trx.BUDGET_TYPE, trx.VERSION_NUMBER, trx.VERSION_NAME, trx.VERSION_DESCRIPTION, trx.BUDGET_STATUS_CODE, trx.BUDGET_STATUS, trx.CURRENT_FLAG, trx.ORIGINAL_FLAG, trx.CURRENT_ORIGINAL_FLAG, trx.BUDGET_ENTRY_METHOD_CODE, trx.LABOR_QUANTITY, trx.LABOR_UNIT_OF_MEASURE, trx.RAW_COST, trx.BURDENED_COST, trx.REVENUE, trx.FIRST_BUDGET_PERIOD, trx.WF_STATUS_CODE, trx.TOTAL_PROJECT_RAW_COST, trx.TOTAL_PROJECT_BURDENED_COST, trx.TOTAL_PROJECT_REVENUE, trx.TASK_ID, trx.TASK_NUMBER, trx.TASK_NAME, trx.TASK_ORGANIZATION, trx.TASK_MANAGER, trx.TASK_START_DATE, trx.TASK_COMPLETION_DATE, trx.TASK_STATUS, trx.TOP_TASK_ID, trx.TOP_TASK_NUMBER, trx.TOP_TASK_NAME, trx.RESOURCE_LIST_MEMBER_ID, trx.PARENT_MEMBER_ID, trx.START_DATE, trx.END_DATE, trx.PA_PERIOD_NAME, trx.GL_PERIOD_NAME, trx.ENCUMBRANCE_TYPE_CODE, trx.ENCUMBRANCE_TYPE, trx.BUDGET, trx.ACTUALS, trx.ENCUMBRANCES, trx.BGT_CONSUMPTION, trx.PROJECT_BUDGET, trx.PROJECT_COMMITMENTS, trx.PROJECT_ACTUALS, trx.PROJ_CMTS_ALL + trx.PROJ_ACTLS_ALL PROJECT_CONSUMPTION, trx.PROJ_UNCONSUMED_FUNDS, trx.PROJ_PERCENT_SPENT_BUDGET, trx.TASK_BUDGET, trx.TASK_COMMITMENTS, trx.TASK_ACTUALS, trx.TASK_CMTS_ALL + trx.TASK_ACTLS_ALL TASK_CONSUMPTION, trx.TASK_UNCONSUMED_FUNDS, trx.TASK_PERCENT_SPENT_BUDGET, trx.PROJECT_REQ_CMT, trx.PROJECT_PO_CMT, trx.PROJECT_AP_CMT, trx.PROJECT_UNUTLFUND_CT, trx.TASK_REQ_CMT, trx.TASK_PO_CMT, trx.TASK_AP_CMT, trx.TASK_UNUTLFUND_CT, trx.PROJ_BALANCE_BGT, trx.TASK_BALANCE_BGT, trx.PROJ_FAILED_FC, trx.TASK_FAILED_FC, TRX.TASK_GROUPING_VAL, TRX.PROJECT_GROUPING_VAL, TRX.FC_START_DATE, TRX.FC_END_DATE, TRX.PROJ_BDGT_ALL, TRX.PROJ_CMTS_ALL, TRX.PROJ_ACTLS_ALL, TRX.PROJ_RMNG_ALL, TRX.PROJ_FC_FAIL_ALL, TRX.TASK_BDGT_ALL, TRX.TASK_CMTS_ALL, TRX.TASK_ACTLS_ALL, TRX.TASK_RMNG_ALL, TRX.TASK_FC_FAIL_ALL, TRX.PROJ_UNCONSUMED_FUNDS_FLAG, TRX.TASK_UNCONSUMED_FUNDS_FLAG, trx.project_id || trx.task_id || trx.GL_PERIOD_NAME ASSC_ID, trx.PROJ_UNCONSUMED_FUNDS PROJ_UNCONSUMED_FUNDS_COM, trx.PROJECT_REQ_CMT PROJECT_REQ_CMT_COM, trx.PROJECT_PO_CMT PROJECT_PO_CMT_COM, TRX.PROJ_ACTLS_ALL PROJ_ACTLS_ALL_COM, trx.TASK_UNCONSUMED_FUNDS TASK_UNCONSUMED_FUNDS_COM, trx.TASK_REQ_CMT TASK_REQ_CMT_COM, trx.TASK_PO_CMT TASK_PO_CMT_COM, trx.TASK_ACTLS_ALL TASK_ACTLS_ALL_COM, trx.ACTUALS ACTUALS_COM, trx.PROJECT_ACTUALS PROJECT_ACTUALS_COM, trx.TASK_ACTUALS TASK_ACTUALS_COM, trx.ENABLE_REVISE_BUDGET ENABLE_REVISE_BUDGET, trx.LANGUAGE FROM PA_ECC_COST_BC_BALANCES trx, pa_tasks pt where trx.task_id = pt.task_id (+) and trx.language in ('US') ) PIVOT ( max(OPERATING_UNIT) as OPERATING_UNIT, max(PROJECT_ORGANIZATION) as PROJECT_ORGANIZATION, max(PROJECT_TYPE_CLASS_CODE) as PROJECT_TYPE_CLASS_CODE, max(PROJECT_STATUS_CODE) as PROJECT_STATUS_CODE, max(PROJECT_SYSTEM_STATUS_CODE) as PROJECT_SYSTEM_STATUS_CODE, max(AMOUNT_TYPE) as AMOUNT_TYPE, max(BOUNDARY_CODE) as BOUNDARY_CODE, max(PROJECT_CONTROL_LEVEL) as PROJECT_CONTROL_LEVEL, max(TASK_CONTROL_LEVEL) as TASK_CONTROL_LEVEL, max(RES_GROUP_CONTROL_LEVEL) as RES_GROUP_CONTROL_LEVEL, max(RESOURCE_CONTROL_LEVEL) as RESOURCE_CONTROL_LEVEL, max(BUDGET_STATUS) as BUDGET_STATUS, max(TASK_ORGANIZATION) as TASK_ORGANIZATION, max(ENCUMBRANCE_TYPE) as ENCUMBRANCE_TYPE, max(PERIODICITY) as PERIODICITY for LANGUAGE in ('US' "US")) ) x where 2=2 Y AR ECC المشروعات, تحديد تكلفة المشروعات: أرصدة الموازنة Imported from Enterprise Command Center Description: أرصدة المشروع الممكَّنة لمراقبة الموازنة Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues D ECC Projects, Projektkosten: Budgetsalden Imported from Enterprise Command Center Description: Für Budgetkontrolle aktivierte Projektsalden Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues E ECC Projects, Costes de Proyectos: Saldos Presupuestarios Imported from Enterprise Command Center Description: Saldos de proyecto con control presupuestario activado Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues F ECC Projects, Projects Costing : Soldes budgétaires Imported from Enterprise Command Center Description: Soldes de projet pour contrôle budgétaire activé Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues I ECC Projects, Determinazione costi progetti: saldi budget Imported from Enterprise Command Center Description: Saldi progetto con controllo budgetario abilitato Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues JA ECC Projects, プロジェクト原価計算: 予算残高 Imported from Enterprise Command Center Description: 予算管理対応プロジェクト残高 Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues KO ECC 프로젝트, 프로젝트 원가 계산: 예산 잔액 Imported from Enterprise Command Center Description: 예산 통제 사용 프로젝트 잔액 Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues RU ECC Проекты, Projects Costing: бюджетные сальдо Imported from Enterprise Command Center Description: Сальдо проектов с контролем исполнения бюджета Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues S ECC Projekt, Projektuppföljning: Budgetsaldon Imported from Enterprise Command Center Description: Saldon för projekt aktiverat för budgetstyrning Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues TR ECC Projeler, Proje Maliyetlendirme: Bütçe Bakiyeleri Imported from Enterprise Command Center Description: Bütçe Kontrolü Etkin Proje Bakiyeleri Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues US ECC Projects, Projects Costing: Budget Balances Imported from Enterprise Command Center Description: Budgetary Control-Enabled Project Balances Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues ZHS ECC Projects, 项目成本计算：预算余额 Imported from Enterprise Command Center Description: 启用预算控制的项目余额 Dataset Key: pa-ds-cost-bcbalances Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues Enterprise Command Center