ECC Projects, Projects Costing: Assets

Description
Categories: Enterprise Command Center
Columns: Record Type, Ecc Spec Id, Project Asset Id, Project Id, Project Number, Project Name, Projfunc Currency Code, Project Type Class Code, Project Type, Asset Number ...
Imported from Enterprise Command Center
Description: Data set for information about assets
Dataset Key: pa-ds-cost-asset
Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA
Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues
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