ECC Cost Management, Overview

Description

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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,
       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