ECC Cost Management, Overview

Description
Categories: Enterprise Command Center
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 Enterprise Command Center
Dataset Key: cst-phc-ovw
Query Procedure: CST_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CST_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
select
x.*
from
(
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"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.organization_code=:organization_code
LOV