ECC Projects, Projects Costing: Assets

select
x.*
from
(
 
	select * from (
	SELECT RECORD_TYPE		  ,
	ECC_SPEC_ID                       ,
	PROJECT_ASSET_ID                   ,
	PROJECT_ID                         ,
	PROJECT_NUMBER			   ,
	PROJECT_NAME                       ,
  	projfunc_currency_code  	   ,
	PROJECT_TYPE_CLASS_CODE		   ,
	PROJECT_TYPE_CLASS		   ,
	PROJECT_TYPE			   ,
	ASSET_NUMBER                       ,
	ASSET_NAME                         ,
	ASSET_DESCRIPTION                  ,
	LOCATION_ID                        ,
	FIXED_ASSET_NUMBER                 ,
	FIXED_ASSET_STATUS                 ,
	FIXED_ASSET_STATUS_CODE            ,
	BUDGETED_COST			   ,
	ESTIMATED_COST			   ,
	DATE_PLACED_IN_SERVICE             ,
	ASSET_CATEGORY_ID		   ,
	ASSET_CATEGORY                     ,
	TOTAL_EXPENDITURES		   ,
	NUMBER_OF_TASKS			   ,
	TXN_PENDING_COST_DIST		   ,
	TXN_PENDING_BURDEN_DIST		   ,
	NUMBER_OF_ASSET_LINES		   ,
	NUMBER_OF_REJ_ASSET_LINES	   ,
	COST_PENDING_SUMMARIZATION	   ,
	COST_PENDING_FINAL_ACC		   ,
	COST_PENDING_AL_GEN		   ,
	COST_AL_PEND_INTF_FA		   ,
	COST_REJ_ASSET_LINES		   ,
	ASSET_RETIRED_IN_FA		   ,
	CAPITAL_HOLD			   ,
	MARKED_FOR_AL_REVERSAL		   ,
	COST_ADJUSTMENT_FLAG               ,
	CAPITALIZED			   ,
	CAPITALIZED_FLAG                   ,
	CAPITALIZED_DATE                   ,
	REVERSAL_DATE                      ,
	CAPITALIZED_COST                   ,
	GROUPED_CIP_COST                   ,
	ORG_ID                             ,
	ORGANIZATION_NAME                  ,
	ASSET_KEY_CCID                     ,
	CAPITAL_EVENT_ID                   ,
	PARENT_ASSET_ID                    ,
	PROJECT_ASSET_TYPE_CODE		   ,
	PROJECT_ASSET_TYPE                 ,
	FA_ASSET_ID                        ,
	BOOK_TYPE_CODE                     ,
	ASSET_UNITS                        ,
	DEPRECIATE_FLAG                    ,
	ESTIMATED_IN_SERVICE_DATE          ,
	ESTIMATED_ASSET_UNITS              ,
	ASSET_PAST_DUE                     ,
	PROJECT_ASSET_LINE_ID              ,
	LINE_DESCRIPTION		   ,
	TASK_ID                            ,
	TASK_NUMBER			   ,
	TASK_NAME                          ,
	CIP_ACCOUNT			   ,
	ORIGINAL_ASSET_COST                ,
	CURRENT_ASSET_COST                 ,
	PROJECT_ASSET_LINE_DETAIL_ID       ,
	GL_DATE                            ,
	ORIGINAL_ASSET_ID                  ,
	TRANSFER_STATUS_CODE               ,
	AL_STATUS_IN_PROJECTS              ,
	TRANSFER_REJECTION_REASON          ,
	AMORTIZE_FLAG                      ,
	NEW_MASTER_FLAG                    ,
	FA_PERIOD_NAME                     ,
	QUANTITY			   ,
	AMOUNT				   ,
	INTERFACE_TO_FA 		   ,
	PO_VENDOR	                   ,
	PO_NUMBER                          ,
	PO_LINE_NUMBER			   ,
	RECEIPT_NUMBER			   ,
	RECEIPT_LINE_NUMBER		   ,
	INVOICE_NO			   ,
	INVOICE_LINE_NUMBER                ,
	INVOICE_DISTRIBUTION_ID            ,
	LINE_TYPE                          ,
	EXPENDITURE_ITEM_ID                ,
	LINE_NUM                           ,
	CIP_COST                           ,
	REVERSED_FLAG                      ,
	PROJ_ASSET_LINE_DTL_UNIQ_ID        ,
	ALERT_TYPE,
	ALERT_TEXT,
	TOTAL_ASSET_COST,
	LANGUAGE
	 FROM pa_ecc_cost_assets where language in ('US') ) PIVOT (
	max(PROJECT_TYPE_CLASS) as PROJECT_TYPE_CLASS ,
	max(FIXED_ASSET_STATUS) as FIXED_ASSET_STATUS ,
	max(CAPITAL_HOLD) as CAPITAL_HOLD ,
	max(CAPITALIZED) as CAPITALIZED ,
	max(ORGANIZATION_NAME) as ORGANIZATION_NAME ,
	max(PROJECT_ASSET_TYPE) as PROJECT_ASSET_TYPE ,
	max(AL_STATUS_IN_PROJECTS) as AL_STATUS_IN_PROJECTS ,
	max(MARKED_FOR_AL_REVERSAL) as MARKED_FOR_AL_REVERSAL ,
	max(ASSET_RETIRED_IN_FA) as ASSET_RETIRED_IN_FA ,
	max(INTERFACE_TO_FA) as INTERFACE_TO_FA ,
	max(ALERT_TEXT) as ALERT_TEXT,
	max(AMORTIZE_FLAG) as AMORTIZE_FLAG,
	max(NEW_MASTER_FLAG) as NEW_MASTER_FLAG,
	max(DEPRECIATE_FLAG) as DEPRECIATE_FLAG
	for LANGUAGE in ('US' "US")) 
) x
where
2=2