ECC Projects, Projects Costing: Transaction Source, SQL1

Description
Columns: Record Type, Ecc Spec Id, Transaction Id, Distribution Id, Source Code, Transaction Source, Batch Name, Document Distribution Type, Document Type, Project Id ...
Imported from ECC
select * from (
SELECT
 RECORD_TYPE           ,
 ECC_SPEC_ID           ,
 TRANSACTION_ID        ,
 DISTRIBUTION_ID       ,
 SOURCE_CODE		   ,
 SOURCE				   ,
 TRANSACTION_SOURCE    ,
 BATCH_NAME ,
 DOCUMENT_DISTRIBUTION_TYPE	,
 DOCUMENT_TYPE		,
 PROJECT_ID            ,
 PROJECT_NAME          ,
 PROJECT_NUMBER        ,
 PROJECT_TYPE          ,
 PROJECT_TYPE_CLASS_CODE	,
 PROJECT_TYPE_CLASS		,
 TASK_ID               ,
 TASK_NUMBER           ,
 TASK_NAME             ,
EXPENDITURE_ITEM_DATE ,
EXPENDITURE_TYPE       ,
QUANTITY               ,
UNIT_OF_MEASURE        ,
 UNIT_OF_MEASURE_M	   ,
 AMOUNT        ,
 TRANSACTION_REFERENCE,
 TRANSACTION_STATUS_CODE,
 TRANSACTION_STATUS,
 EXPENDITURE_ORGANIZATION_ID,
 EXPENDITURE_ORG_NAME,
 OVERRIDE_TO_ORGANIZATION_NAME,
 PREDEFINED_FLAG,
 COSTED_FLAG          ,
 ALLOW_ADJUSTMENTS_FLAG ,
 GL_ACCOUNTED_FLAG	 ,
 COST_BURDENED_FLAG	 ,
 ALLOW_BURDEN_FLAG	 ,
 DEBIT_ACCOUNT 	 ,
 CREDIT_ACCOUNT 	 ,
 WORK_TYPE 			,
 INVENTORY_ITEM     ,
 LOCATION_CODE      ,
 ASSIGNMENT_NAME    ,
 EMPLOYEE_NUMBER    ,
 EMPLOYEE_NAME      ,
 WIP_RESOURCE       ,
 SUPPLIER_NAME      ,
 PO_NUMBER  		,
 PO_LINE_NUMBER 	,
 PO_DIST_LINE_NUMBER,
 RECEIPT_NUMBER 	,
 RECEIPT_LINE_NUMBER,
 INVOICE_NO 		,
 INVOICE_LINE_NUMBER,
 INV_DIST_LINE_NUMBER,
 ALERT_TYPE,
 ALERT_TEXT,
 LANGUAGE
FROM pa_ecc_cost_txns where language in ('US') ) PIVOT(
max(SOURCE) as SOURCE,
max(PROJECT_TYPE_CLASS) as PROJECT_TYPE_CLASS,
max(EXPENDITURE_ORG_NAME) as EXPENDITURE_ORG_NAME,
max(UNIT_OF_MEASURE_M) as UNIT_OF_MEASURE_M,
max(TRANSACTION_STATUS) as TRANSACTION_STATUS,
max(PREDEFINED_FLAG) as PREDEFINED_FLAG,
max(COSTED_FLAG) as COSTED_FLAG,
max(ALLOW_ADJUSTMENTS_FLAG) as ALLOW_ADJUSTMENTS_FLAG,
max(GL_ACCOUNTED_FLAG) as GL_ACCOUNTED_FLAG,
max(COST_BURDENED_FLAG) as COST_BURDENED_FLAG,
max(ALLOW_BURDEN_FLAG) as ALLOW_BURDEN_FLAG,
max(ALERT_TYPE) as ALERT_TYPE,
max(ALERT_TEXT) as ALERT_TEXT
for LANGUAGE in ('US' "US"))