ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4AB66AD8E05362FB09051F8BY select x.* from ( select * from ( SELECT RECORD_TYPE, ECC_SPEC_ID, PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, ORG_ID, OPERATING_UNIT, PROJECT_START_DATE, PROJECT_COMPLETION_DATE, PROJECT_TYPE, PROJECT_TYPE_CLASS_CODE, PROJECT_STATUS_CODE, PROJECT_SYSTEM_STATUS_CODE, PROJFUNC_CURRENCY_CODE, REVENUE_ACCRUAL_METHOD, INVOICE_METHOD, ENABLE_TOP_TASK_INV_MTH_FLAG, BILLING_CYCLE_ID, BILLING_CYCLE_NAME, BILLING_OFFSET, NEXT_INVOICE_DATE, FUNDING_TASK_ID, FUNDING_TASK_NUMBER, FUNDING_TASK_NAME, TASK_START_DATE, TASK_COMPLETION_DATE, AGREEMENT_ID, AGREEMENT_NUM, CUSTOMER_ID, PARTY_NUMBER, PARTY_NAME, AGREEMENT_ORGANIZATION_ID, AGREEMENT_CURRENCY_CODE, AGREEMENT_START_DATE, AGREEMENT_EXPIRATION_DATE, REVENUE_LIMIT_FLAG, INVOICE_LIMIT_FLAG, REVENUE_HARD_LIMIT, INVOICE_HARD_LIMIT, TERM_ID, TERM_NAME, AGREEMENT_DESCRIPTION, BILLING_SEQUENCE, FUNDING_CURRENCY_CODE, TOTAL_UNBASELINED_AMOUNT, TOTAL_BASELINED_AMOUNT, TOTAL_ALLOCATED, TOTAL_REVENUE, INVOICED_AMOUNT, REVENUE_WRITEOFF, RETENTION_WITHHELD, RETENTION_BILLED, PROJECT_CURRENCY_CODE, PROJECT_UNBASELINED_AMOUNT, PROJECT_BASELINED_AMOUNT, PROJECT_ALLOCATED, PROJECT_REVENUE, PROJECT_INVOICED_AMOUNT, PROJECT_REVENUE_WRITEOFF, PROJECT_RETENTION_WITHHELD, PROJECT_RETENTION_BILLED, SPF_PROJFUNC_CURRENCY_CODE, PROJFUNC_UNBASELINED_AMOUNT, PROJFUNC_BASELINED_AMOUNT, PROJFUNC_ALLOCATED, PROJFUNC_REVENUE, PROJFUNC_INVOICED_AMOUNT, PROJFUNC_REVENUE_WRITEOFF, PROJFUNC_RETENTION_WITHHELD, PROJFUNC_RETENTION_BILLED, BUDGET_VERSION_ID, PROJECT_ITD_BUDGET, PROJECT_ITD_REVENUE, concession_amount, project_concession_amount, projfunc_concession_amount, PROJECT_ID||':'||FUNDING_TASK_ID DS_ASSOC_PRJ_TSK_ATTR, LANGUAGE FROM PA_ECC_BILL_FUNDING where language in ('US'))PIVOT ( max(OPERATING_UNIT) as OPERATING_UNIT, max(REVENUE_HARD_LIMIT) as REVENUE_HARD_LIMIT, max(INVOICE_HARD_LIMIT) as INVOICE_HARD_LIMIT, max(TERM_NAME) as TERM_NAME for LANGUAGE in ('US' "US")) ) x where 2=2 AR ECC المشروعات, تحرير فواتير المشروعات: التمويل Imported from Enterprise Command Center Description: تفاصيل التمويل لملخص تحرير فواتير المشروعات Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues D ECC Projects, Projektfakturierung: Finanzierung Imported from Enterprise Command Center Description: Projektfakturierungsübersicht - Finanzierungsdetails Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues E ECC Projects, Facturación de Proyectos: Financiación Imported from Enterprise Command Center Description: Detalles de Financiación de Resumen de Facturación de Proyectos Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues F ECC Projects, Facturation projets : Financement Imported from Enterprise Command Center Description: Facturation projets - Détails financement de synthèse Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues I ECC Projects, Fatturazione progetti: fondi Imported from Enterprise Command Center Description: Dettagli fondi sintetico fatturazione progetti Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues JA ECC Projects, プロジェクト請求: 資金 Imported from Enterprise Command Center Description: プロジェクト請求要約資金詳細 Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues KO ECC 프로젝트, 프로젝트 청구: 자금조달 Imported from Enterprise Command Center Description: 프로젝트 청구 요약 자금조달 상세내역 Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues RU ECC Проекты, Выст. счетов по проектам: финансир. Imported from Enterprise Command Center Description: Выст. счетов по проектам: сводные данные финансир. Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues S ECC Projekt, Projektfakturering: Finansiering Imported from Enterprise Command Center Description: Projektfakturering: Översikt - finansieringsdetaljer Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues TR ECC Projeler, Proje Faturalama: Fonlama Imported from Enterprise Command Center Description: Proje Faturalama Özeti Fonlama Detayları Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues US ECC Projects, Projects Billing: Funding Imported from Enterprise Command Center Description: Projects Billing Summary Funding Details Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues ZHS ECC Projects, 项目开单：资金分配 Imported from Enterprise Command Center Description: 项目开单汇总资金分配详细信息 Dataset Key: pa-ds-bill-funding Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues Enterprise Command Center