ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4ABF6AD8E05362FB09051F8BY select x.* from ( select * from ( SELECT RECORD_TYPE , ECC_SPEC_ID , TRANSACTION_ID , DISTRIBUTION_ID , SOURCE_CODE , SOURCE , TRANSACTION_SOURCE , BATCH_NAME , DOCUMENT_DISTRIBUTION_TYPE , DOCUMENT_TYPE , PROJECT_ID , PROJECT_NAME , PROJECT_NUMBER , PROJECT_TYPE , PROJECT_TYPE_CLASS_CODE , PROJECT_TYPE_CLASS , TASK_ID , TASK_NUMBER , TASK_NAME , EXPENDITURE_ITEM_DATE , EXPENDITURE_TYPE , QUANTITY , UNIT_OF_MEASURE , UNIT_OF_MEASURE_M , AMOUNT , TRANSACTION_REFERENCE, TRANSACTION_STATUS_CODE, TRANSACTION_STATUS, EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ORG_NAME, OVERRIDE_TO_ORGANIZATION_NAME, PREDEFINED_FLAG, COSTED_FLAG , ALLOW_ADJUSTMENTS_FLAG , GL_ACCOUNTED_FLAG , COST_BURDENED_FLAG , ALLOW_BURDEN_FLAG , DEBIT_ACCOUNT , CREDIT_ACCOUNT , WORK_TYPE , INVENTORY_ITEM , LOCATION_CODE , ASSIGNMENT_NAME , EMPLOYEE_NUMBER , EMPLOYEE_NAME , WIP_RESOURCE , SUPPLIER_NAME , PO_NUMBER , PO_LINE_NUMBER , PO_DIST_LINE_NUMBER, RECEIPT_NUMBER , RECEIPT_LINE_NUMBER, INVOICE_NO , INVOICE_LINE_NUMBER, INV_DIST_LINE_NUMBER, ALERT_TYPE, ALERT_TEXT, LANGUAGE, TOP_TASK_ID, TOP_TASK_NUMBER, TOP_TASK_NAME, FUNDING_TASK_ID, BILLPROJ_DISPLAY_FLAG, PROJECT_ID||':'||FUNDING_TASK_ID DS_ASSOC_PRJ_TSK_ATTR, PROJECT_ID||':'||FUNDING_TASK_ID||':'||PERIOD_NAME DS_ASSOC_PRJ_TSK_PER_ATTR, PERIOD_NAME, GL_DATE, GL_PERIOD_NAME_SRC, PERIOD_DISP_FLAG, ACCT_AMOUNT, ACCT_CURRENCY, TRX_SOURCE_NAME_CODE, CASE WHEN TRX_SOURCE_NAME_CODE IN ('PO RECEIPT', 'PO RECEIPT NRTAX', 'PO RECEIPT PRICE ADJ') THEN 'PEND_PO' WHEN TRX_SOURCE_NAME_CODE IN ('AP NRTAX', 'AP VARIANCE', 'INTERPROJECT_AP_INVOICES', 'AP EXPENSE', 'AP INVOICE', 'AP DISCOUNTS') THEN 'PEND_VI' WHEN TRX_SOURCE_NAME_CODE <> 'ORACLE TIME AND LABOR' THEN 'PEND_SRC' ELSE NULL END TRX_SRC_TYPE_CODE, CASE WHEN TRX_SOURCE_NAME_CODE IN ('PO RECEIPT', 'PO RECEIPT NRTAX', 'PO RECEIPT PRICE ADJ') THEN pa_utils.get_lookup_values('PA_ECC_SRC_TYPE_CODE', 'PEND_PO', language) WHEN TRX_SOURCE_NAME_CODE IN ('AP NRTAX', 'AP VARIANCE', 'INTERPROJECT_AP_INVOICES', 'AP EXPENSE', 'AP INVOICE', 'AP DISCOUNTS') THEN pa_utils.get_lookup_values('PA_ECC_SRC_TYPE_CODE', 'PEND_VI', language) WHEN TRX_SOURCE_NAME_CODE <> 'ORACLE TIME AND LABOR' THEN pa_utils.get_lookup_values('PA_ECC_SRC_TYPE_CODE', 'PEND_SRC', language) ELSE NULL END TRX_SRC_TYPE FROM pa_ecc_cost_txns where language in ('US') ) PIVOT( max(SOURCE) as SOURCE, max(PROJECT_TYPE_CLASS) as PROJECT_TYPE_CLASS, max(EXPENDITURE_ORG_NAME) as EXPENDITURE_ORG_NAME, max(UNIT_OF_MEASURE_M) as UNIT_OF_MEASURE_M, max(TRANSACTION_STATUS) as TRANSACTION_STATUS, max(PREDEFINED_FLAG) as PREDEFINED_FLAG, max(COSTED_FLAG) as COSTED_FLAG, max(ALLOW_ADJUSTMENTS_FLAG) as ALLOW_ADJUSTMENTS_FLAG, max(GL_ACCOUNTED_FLAG) as GL_ACCOUNTED_FLAG, max(COST_BURDENED_FLAG) as COST_BURDENED_FLAG, max(ALLOW_BURDEN_FLAG) as ALLOW_BURDEN_FLAG, max(ALERT_TYPE) as ALERT_TYPE, max(ALERT_TEXT) as ALERT_TEXT, max(TRX_SRC_TYPE) as TRX_SRC_TYPE for LANGUAGE in ('US' "US")) ) x where 2=2 AR ECC المشروعات, تحديد تكلفة المشروعات: مصدر الحركة Imported from Enterprise Command Center Description: مجموعة البيانات للمعلومات الخاصة بحركات المصدر المعلقة Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues D ECC Projects, Projektkosten: Transaktionsherkunft Imported from Enterprise Command Center Description: DatenSet mit Informationen über anstehende Herkunftstransaktionen Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues E ECC Projects, Costes de Proyectos: Origen de Transacción Imported from Enterprise Command Center Description: Juego de datos para información sobre transacciones de origen pendiente Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues F ECC Projects, Projects Costing : Origine des mouvements Imported from Enterprise Command Center Description: Jeu de données pour informations sur mouvements en attente d'origine Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues I ECC Projects, Determinaz.ne costi progetti: origine transazioni Imported from Enterprise Command Center Description: Serie di dati per le informazioni sulle transazioni in sospeso nell'origine Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues JA ECC Projects, プロジェクト原価計算: 取引ソース Imported from Enterprise Command Center Description: 保留中ソース取引に関する情報のデータ・セット Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues KO ECC 프로젝트, 프로젝트 원가 계산: 거래 출처 Imported from Enterprise Command Center Description: 대기중 출처 거래 정보에 대한 데이터 세트 Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues RU ECC Проекты, Projects Costing: источник транзакции Imported from Enterprise Command Center Description: Набор данных об отложенных исходных транзакциях Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues S ECC Projekt, Projektuppföljning: Transaktionskälla Imported from Enterprise Command Center Description: Datauppsättning för information om avvaktande källtransaktioner Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues TR ECC Projeler, Proje Maliyetlendirme: İşlem Kaynağı Imported from Enterprise Command Center Description: Bekleyen kaynak işlemleri hakkındaki bilgiler için veri kümesi Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues US ECC Projects, Projects Costing: Transaction Source Imported from Enterprise Command Center Description: Data set for information about pending source transactions Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues ZHS ECC Projects, 项目成本计算：事务处理来源 Imported from Enterprise Command Center Description: 待定来源事务处理相关信息的数据集 Dataset Key: pa-ds-cost-source-imp Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_TXN_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues Enterprise Command Center