ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4AF56AD8E05362FB09051F8BY select x.* from ( select * from ( SELECT RECORD_TYPE, ECC_SPEC_ID, RECORD_IDENTIFIER, ORG_ID, OU_NAME, DELIVER_TO_LOCATION, ADDRESS, ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3, COUNTRY, TOWN_OR_CITY, STATE, ITEM_ID, CATEGORY_ID, ITEM_DESCRIPTION, ITEM_NUMBER, PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE, CATEGORY_ITEM, UOM, DATE_YEAR, DATE_TRX, DATE_QUARTER, PROMISED_DATE, QUANTITY_CANCELLED, QUANTITY_REJECTED, QUANTITY_RECEIVED, UNIT_PRICE, QUANTITY, LEAD_TIME, LEAD_TIME_UNIT, TOTAL_SPEND, TYPE_REQ, DOC_TYPE, TYPE_AGR, OFF_CONTRACT_SPEND, PO_TYPE_LOOKUP_CODE, CONTRACT_SPEND, QUANTITY_ACCEPTED, QUANTITY_BILLED, QUANTITY_OVERDUE, PRICE_OVERRIDE, ORDER_NUMBER, AGREEMENT_NUMBER, REQUISITION_NUMBER, PROJECT_NUMBER, PROJECT_NAME, TASK_NUMBER, TASK_NAME, TASK_SCH_START_DATE, TASK_SCH_END_DATE, SUPPLIER_NAME, SUPPLIER_NUMBER, CURRENCY_CODE, PO_STATUS, ORDER_STATUS_CODE, REQUISITION_STATUS, AGREEMENT_STATUS, ORGANIZATION_ID, ORGANIZATION_NAME, ORGANIZATION_CODE, TYPE_LINE, SUPPLIER_TYPE, SUPPLIER_SITE, AUTHORIZATION_STATUS, ORDER_DATE, BUYER_NAME, PROJECT_STATUS, PROJECT_MANAGER_NAME, INVENTORY_ITEM_STATUS_CODE, LIST_PRICE, MARKET_PRICE, INVENTORY_PLANNING_METHOD, ITEM_LONG_DESCRIPTION, PO_LINE_STATUS, CREATION_DATE, SUGGESTED_BUYER_NAME, QUANTITY_DELIVERED, REQUESTOR_NAME, AMOUNT_AGREED, AMOUNT_RELEASED, RFQ_NUMBER, NEGOTIATION_STATUS, NEGOTIATION_TITLE, START_DATE, END_DATE, PREVIEW_DATE, PUBLISH_DATE, AWARD_DATE, AWARD_AMOUNT, PO_DISTRIBUTION_ID, LINE_LOCATION_ID, PO_HEADER_ID, PO_LINE_ID, DISTRIBUTION_ID, REQUISITION_LINE_ID, REQUISITION_HEADER_ID, AMOUNT1, AMOUNT2, AMOUNT3, AMOUNT4, AMOUNT5, AMOUNT6, AMOUNT7, AMOUNT8, AMOUNT9, PROJECT_ID, CLOSED_DATE, BUSINESS_TYPE, ASL_STATUS, MANUFACTURER, SUPPLIER_ITEM, ONE_TIME_FLAG, QUALITY_RATING, PRICE_COMPLIANCE, SHIPMENT_ONTIME_FLAG, PO_LINE_ATTACHMENT_TEXT, END_DATE_MONTH, END_DATE_YEAR, PA_COST_CODE, QUANTITY_RECEIVED QUANTITY_COMMITED, END_DATE NEED_BY_DATE, LANGUAGE_CODE FROM PO_ECC_ITEMS_PROCUREMENT_V WHERE LANGUAGE_CODE in ('US') ) PIVOT( MAX(country) as country, MAX(inventory_planning_method) as inventory_planning_method, MAX(negotiation_status) as negotiation_status, MAX(OU_NAME) as OU_NAME, MAX(ORGANIZATION_NAME) as ORGANIZATION_NAME, MAX(AGREEMENT_STATUS) as AGREEMENT_STATUS, MAX(PO_TYPE_LOOKUP_CODE) as PO_TYPE_LOOKUP_CODE, MAX(REQUISITION_STATUS) as REQUISITION_STATUS, MAX(PO_STATUS) AS PO_STATUS for LANGUAGE_CODE in ('US' "US")) ) x where 2=2 AR ECC شراء المشروع, تحليل الصنف Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: D ECC Projektbeschaffung, Artikelanalyse Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: E ECC Project Procurement, Análisis Artículo Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: F ECC Project Procurement, Analyse articles Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: I ECC Acquisti progetto, Analisi articoli Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: JA ECC プロジェクト調達, 品目分析 Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: KO ECC 프로젝트 조달, 품목 분석 Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: RU ECC Закупки для проекта, Анализ позиций Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: S ECC Projektupphandling, Artikelanalys Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: TR ECC Proje Tedariği, Kalem Analizi Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: US ECC Project Procurement, Item Analysis Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: ZHS ECC Project Procurement, 产品分析 Imported from Enterprise Command Center Dataset Key: po-proc-item Query Procedure: PO_PPCC_ECC_UTIL_PVT.LOAD_ECC_DATA_FULL Security Procedure: Enterprise Command Center