ECC Inventory Management, Inventory Cycle Counting

select
x.*
from
(
SELECT * FROM ( select iecv.ecc_spec_id, iecv.ORGANIZATION_ID,
							iecv.ORGANIZATION_CODE,
							iecv.CYCLE_COUNT_ENTRY_ID,
							iecv.CYCLE_COUNT_HEADER_ID,
							iecv.CYCLE_COUNT_HEADER_NAME,
							iecv.ITEM_DESCRIPTION,
							iecv.ITEM,
							iecv.REVISION,
							iecv.SUBINVENTORY,
							iecv.LOCATOR,
							iecv.LOT,
							iecv.PRIMARY_UOM,
							iecv.PRIMARY_QTY,
							iecv.PRIMARY_COUNT_QTY,
							iecv.SCHEDULE_DATE,
							iecv.COUNT_DUE_DATE,
							iecv.COUNT_DATE,
							iecv.COUNT_TYPE_CODE,
							iecv.COUNT_QTY_UOM,
							iecv.COUNT_TYPE,
							iecv.COUNTER,
							iecv.APPROVAL_DATE,
							iecv.APPROVER,
							iecv.ADJ_QUANTITY,
							iecv.VALUE,
							iecv.VALUE_CHANGE,
							iecv.VALUE_CHANGE_DATE,
							iecv.CC_CLASS,
							iecv.ENTRY_STATUS_CODE,
							iecv.STATUS,
							iecv.HIT_MISS_TOLERANCE_POSITIVE,
							iecv.HIT_MISS_TOLERANCE_NEGATIVE,
							iecv.LAST_UPDATE_DATE,
							iecv.INVENTORY_ITEM_ID,
							iecv.ITEM_LAST_SCHEDULE_DATE,
							iecv.UNSCHEDULED_ITEM_DATE,
							iecv.OUTERMOST_LPN,
							iecv.COST_GROUP,
							iecv.HIT_MISS,
							iecv.LANGUAGE,
							iecv.CC_WORKFLOW_ENABLED_FLAG,cc_workflow_flag from inv_ecc_cycle_v iecv where language in ('US'))  PIVOT (max(ITEM_DESCRIPTION) as ITEM_DESCRIPTION, max(COUNT_TYPE) as COUNT_TYPE, max(STATUS) as STATUS for LANGUAGE in ('US' "US"))
) x
where
2=2