ECC Cost Management, Manufacturing (Process), SQL1

Description
Columns: Data Source, Ecc Spec Id, Org Type Code, Data Type Code, Data Source Grp Code, Data Source Desc Code, Transaction Id, Last Update Date, Creation Date, Organization Id ...
Imported from ECC
SELECT * FROM (SELECT
ORG_TYPE  ,
DATA_SOURCE,
ECC_SPEC_ID ,
DATA_TYPE    ,
DATA_SOURCE_GRP,
DATA_SOURCE_DESCRIPTION    ,
ORG_TYPE_CODE              ,
DATA_TYPE_CODE             ,
DATA_SOURCE_GRP_CODE       ,
DATA_SOURCE_DESC_CODE      ,
TRANSACTION_ID             ,
LAST_UPDATE_DATE           ,
CREATION_DATE              ,
ORGANIZATION_ID            ,
TRANSACTION_QUANTITY       ,
TRANSACTION_UOM            ,
TRANSACTION_DATE           ,
TRANSACTION_MONTH          ,
TXN_PROCESSING_STATUS      ,
TXN_PROCESSING_STATUS_CODE ,
PRIMARY_COST_METHOD        ,
ORGANIZATION_CODE          ,
ORGANIZATION_NAME          ,
COST_ORGANIZATION          ,
MASTER_ORGANIZATION        ,
SOB_NAME                   ,
PERIOD_SET_NAME            ,
CHART_OF_ACCOUNTS_NAME     ,
ORG_CURRENCY_CODE          ,
OPERATING_UNIT             ,
LEGAL_ENTITY               ,
PERIOD_NAME                ,
PERIOD_YEAR                ,
PERIOD_NUM                 ,
PERIOD_STATUS              ,
RESOURCES                  ,
RESOURCE_USAGE             ,
COMPLETED_IND              ,
EVENT_ID                   ,
OVERRIDED_PROTECTED        ,
OVERRIDED_PROTECTED_IND    ,
REASON_CODE                ,
START_DATE                 ,
END_DATE                   ,
DELETE_MARK                ,
TEXT_CODE                  ,
INSTANCE_ID                ,
SEQUENCE_DEPENDENT_IND     ,
REVERSE_ID                 ,
REASON_ID                  ,
BATCH_NO                   ,
BATCH_STATUS_DESCRIPTION   ,
ACTUALSTARTDATE            ,
ACTUALCOMPDATE             ,
CLOSEDATE                  ,
NULL REQUEST_ID            ,
CONCURRENT_PROGRAM_NAME    ,
LANGUAGE                   ,
PERIOD_STATUS_CODE         ,
COSTING_PERIOD_STATUS_CODE ,
COSTING_CALENDAR_CODE      ,
COSTING_PERIOD_CODE        ,
COSTING_PERIOD_STATUS
FROM CST_ECC_PHC_RSRC_UAC_TXNS_V
where language in ('US'))  PIVOT     (max(PERIOD_STATUS) as PERIOD_STATUS,
                                              max(ORG_TYPE) as ORG_TYPE,
                                              max(DATA_TYPE) as DATA_TYPE,
                                              max(DATA_SOURCE_GRP) as DATA_SOURCE_GRP,
                                              max(DATA_SOURCE_DESCRIPTION) as DATA_SOURCE_DESCRIPTION,
                                              max(TXN_PROCESSING_STATUS) as TXN_PROCESSING_STATUS,
                                              max(OVERRIDED_PROTECTED) as OVERRIDED_PROTECTED,
                                              max(ORGANIZATION_NAME) as ORGANIZATION_NAME,
                                              max(OPERATING_UNIT) as OPERATING_UNIT,
                                              max(CONCURRENT_PROGRAM_NAME) as CONCURRENT_PROGRAM_NAME,
                                              max(BATCH_STATUS_DESCRIPTION) as BATCH_STATUS_DESCRIPTION,
											  max(COSTING_PERIOD_STATUS) as COSTING_PERIOD_STATUS
                                   for LANGUAGE in ('US' "US"))