ECC Quality Management, Sales Transaction

select
x.*
from
(
SELECT * FROM CN_ECC_TRX_V  PIVOT
										(max(API_OPERATING_UNIT) 		as API_OPERATING_UNIT,
										 max(OPERATING_UNIT)     		as OPERATING_UNIT,
										 max(PMT_OPERATING_UNIT)     	as PMT_OPERATING_UNIT,
										 max(PAYSHEET_OPERATING_UNIT)   as PAYSHEET_OPERATING_UNIT,
										 max(PAYRUN_OPERATING_UNIT)     as PAYRUN_OPERATING_UNIT,
										 max(API_ROLE)    				as API_ROLE,
										 max(ROLE)     					as ROLE,
										 max(PAYSHEET_ROLE)     		as PAYSHEET_ROLE,
										 max(PMT_ROLE)     				as PMT_ROLE,
										 max(API_COMP_GROUP)     		as API_COMP_GROUP,
										 max(COMPENSATION_GROUP)     	as COMPENSATION_GROUP,
										 max(CREDIT_RECEIVER)			as CREDIT_RECEIVER
										 for LANGUAGE in ('US' "US"))
) x
where
2=2