ECC Project Procurement, Item Analysis

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