ECC Cost Management, Overview, 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, Inventory Item 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,
       INVENTORY_ITEM_ID,
       ORGANIZATION_ID,
       TRANSACTION_MONTH,
       ITEM_NAME,
       ITEM_DESCRIPTION,
       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_STATUS,
       SUBINVENTORY_CODE,
       PERIOD_YEAR,
       PERIOD_NUM,
       TRANSACTION_TYPE_NAME,
       TRANSACTION_DATE,
       LANGUAGE,
       TXN_PROCESSING_STATUS,
       TXN_PROCESSING_STATUS_CODE,
       PERIOD_STATUS_CODE,
       COSTING_PERIOD_STATUS_CODE,
       COSTING_CALENDAR_CODE,
       COSTING_PERIOD_CODE,
       COSTING_PERIOD_STATUS
       FROM CST_ECC_PHC_OVW_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(ITEM_DESCRIPTION) as ITEM_DESCRIPTION,
                                              max(ORGANIZATION_NAME) as ORGANIZATION_NAME,
                                              max(OPERATING_UNIT) as OPERATING_UNIT,
                                              max(TRANSACTION_TYPE_NAME) as TRANSACTION_TYPE_NAME,
											  max(COSTING_PERIOD_STATUS) as COSTING_PERIOD_STATUS
                                   for LANGUAGE in ('US' "US"))