ECC Cost Management, Overview
Description
Categories: Enterprise Command Center
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
Dataset Key: cst-phc-ovw
Query Procedure: CST_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CST_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run
ECC Cost Management, Overview and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Code |
|
LOV |