ECC Projects, Projects Costing: Project and Task, SQL1

Description
Columns: Record Type, Ecc Spec Id, Project Id, Project Number, Project Name, Current Pa Period, Current Gl Period, Org Id, Currency, Project Status ...
Imported from ECC
select * from (
SELECT RECORD_TYPE                   	,
ECC_SPEC_ID                   	,
PROJECT_ID						,
PROJECT_NUMBER					,
PROJECT_NAME						,
CURRENT_PA_PERIOD				,
CURRENT_GL_PERIOD				,
ORG_ID							,
OPERATING_UNIT					,
PROJECT_ORGANIZATION				,
CURRENCY							,
PROJECT_STATUS					,
PROJECT_STATUS_CODE				,
PROJECT_TYPE						,
PROJECT_TYPE_CLASS				,
PROJECT_TYPE_CLASS_CODE			,
PROJECT_MANAGER               	,
PROJECT_START_DATE            	,
PROJECT_COMPLETION_DATE       	,
PROJ_EXPENDITURE_BUDGET			,
PROJ_TOTAL_EXPENDITURES			,
PROJ_NON_LABOR_COST				,
PROJ_LABOR_COST					,
PROJ_WIP_COST					,
PROJ_RAW_COST					,
PROJ_BURDEN_COST					,
PROJ_NON_BILLABLE_EXPENDITURE	,
PROJ_BILLABLE_EXPENDITURES		,
PROJ_BILLABLE_UNBILLED			,
PROJ_BILLABLE_ONHOLD				,
PROJ_ACC_EXPENDITURE_VALUE		,
PROJ_UNACC_EXPENDITURE_VALUE		,
PROJ_ACC_EXCEPTION_VALUE			,
PROJ_CAPITALIZABLE_COST			,
PROJ_CAPITALIZED_COST			,
PROJ_NON_CAP_COST				,
PROJ_CAP_COST_ON_HOLD			,
PROJ_COST_PEND_SUMMMARIZATION	,
PROJ_CIP_COST                   ,
PROJ_COST_PEND_AL_GEN           ,
PROJ_COST_PENDING_FINAL_ACC		,
PROJ_COST_AL_PEND_INTF_FA		,
PROJ_COST_REJECTED_AL			,
PROJ_NUM_REJECTED_AL				,
PROJ_COST_UNASG_AL				,
PROJ_NUM_UNASG_AL				,
PROJ_NUMBER_OF_ASSETS			,
PROJ_NUMBER_OF_TASKS				,
PROJ_GROUPING_METHOD				,
PROJ_GRP_SUPPLIER_INVOICE		,
PROJ_ASSET_COST_ALLOC_MHD		,
PROJ_EVENT_PROCESS_METHOD		,
PROJ_ALLOW_INTEREST_FLAG			,
PROJ_TXN_PEND_COST_DIST			,
PROJ_TXN_PEND_BURDEN_DIST		,
PROJ_UNRELEASED_TRANSACTIONS		,
PROJ_UNCOSTED_TRANSACTIONS		,
PROJ_COSTED_TRANSACTIONS			,
PROJ_UNACCOUNTED_TRANSACTIONS	,
PROJ_PEND_BURDEN_TRANSACTIONS	,
PROJ_PEND_PREDEF_SOURCE			,
PROJ_PENDING_IMPORT				,
PROJ_ENBL_BURDEN_COST_ACC		,
PROJ_CAPITAL_COST_TYPE          ,
GROUPED_TASK_ID				,
GROUPED_TASK_NUMBER,
GROUPED_TASK_NAME,
TASK_ID							,
TASK_NUMBER                   	,
TASK_NAME                     	,
TASK_ORGANIZATION				,
SERVICE_TYPE						,
WORK_TYPE						,
TOP_TASK_ID                   	,
TOP_TASK_NAME                 	,
TASK_MANAGER						,
PARENT_TASK_ID                	,
PARENT_TASK_NAME              	,
TASK_START_DATE					,
TASK_COMPLETION_DATE          	,
TASK_EXPENDITURE_BUDGET			,
TASK_TOTAL_EXPENDITURES			,
TASK_NON_LABOR_COST				,
TASK_LABOR_COST					,
TASK_WIP_COST					,
TASK_RAW_COST					,
TASK_BURDEN_COST					,
BURDEN_SCHEDULE					,
BILLABLE_FLAG					,
IS_TASK_BILLABLE					,
IS_TASK_CAPITALIZABLE			,
TASK_NON_BILLABLE_EXPENDITURES	,
TASK_BILLABLE_EXPENDITURES		,
TASK_BILLABLE_UNBILLED			,
TASK_BILLABLE_ONHOLD				,
TASK_ACC_EXPENDITURES_VALUE		,
TASK_UNACC_EXPENDITURES_VALUE	,
TASK_ACC_EXPCEPTION_VALUE		,
TASK_CAPTITALIZABLE_COST			,
TASK_CAPITALIZED_COST			,
TASK_CAPTITALIZABLE_ON_HOLD		,
TASK_NON_CAPITALIZED_COST		,
TASK_COST_PEND_SUMMARIZATION		,
TASK_COST_PENDING_FINAL_ACC		,
TASK_TXN_PENDING_DIST			,
TASK_TXN_PENDING_BURDEN_DIST		,
TASK_UNRELEASED_TRANSACTIONS		,
TASK_UNCOSTED_TRANSACTIONS		,
TASK_UNACCOUNTED_TRANSACTIONS	,
TASK_PEND_BURDEN_TRANSACTIONS	,
TASK_PENDING_PREDEF_SOURCE		,
TASK_PENDING_IMPORT				,
BL_XFER_PRICE_SCHEDULE_LABOR		,
BL_XFER_PRICE_SCHEDULE_NL		,
TASK_PLAN_CAPITALIZABLE_COST		,
TASK_PLAN_NONCAP_COST			,
TASK_CIP_COST					,
TASK_COST_PEND_AL_GEN			,
TASK_COST_UNASG_AL				,
TASK_NUM_UNASG_AL				,
TASK_COST_AL_PEND_INTF_FA		,
TASK_COST_REJECTED_AL			,
TASK_NUM_REJECTED_AL			,
TASK_NUMBER_OF_ASSETS			,
ASSET_ASGN_EXISTS_CODE			,
ASSET_ASSIGNMENT_EXISTS			,
COMMON_COSTS						,
CROSS_CHARGE_ENABLED				,
LANGUAGE FROM pa_ecc_cost_prj_task ) PIVOT (
max(OPERATING_UNIT) as OPERATING_UNIT,
max(PROJECT_ORGANIZATION) as PROJECT_ORGANIZATION,
max(PROJECT_STATUS_CODE) as PROJECT_STATUS_CODE,
max(PROJECT_TYPE_CLASS) as PROJECT_TYPE_CLASS,
max(PROJ_GROUPING_METHOD) as PROJ_GROUPING_METHOD,
max(PROJ_GRP_SUPPLIER_INVOICE) as PROJ_GRP_SUPPLIER_INVOICE,
max(PROJ_ASSET_COST_ALLOC_MHD) as PROJ_ASSET_COST_ALLOC_MHD,
max(PROJ_EVENT_PROCESS_METHOD) as PROJ_EVENT_PROCESS_METHOD,
max(PROJ_ALLOW_INTEREST_FLAG) as PROJ_ALLOW_INTEREST_FLAG,
max(PROJ_ENBL_BURDEN_COST_ACC) as PROJ_ENBL_BURDEN_COST_ACC,
max(PROJ_CAPITAL_COST_TYPE) as PROJ_CAPITAL_COST_TYPE,
max(TASK_ORGANIZATION) as TASK_ORGANIZATION,
max(SERVICE_TYPE) as SERVICE_TYPE,
max(WORK_TYPE) as WORK_TYPE,
max(IS_TASK_BILLABLE) as IS_TASK_BILLABLE,
max(IS_TASK_CAPITALIZABLE) as IS_TASK_CAPITALIZABLE,
max(CROSS_CHARGE_ENABLED) as CROSS_CHARGE_ENABLED ,
max(ASSET_ASSIGNMENT_EXISTS) as ASSET_ASSIGNMENT_EXISTS,
max(COMMON_COSTS) as COMMON_COSTS
for LANGUAGE in ('US' "US"))