ECC Cost Management, Manufacturing (Process)

Description

Imported from Enterprise Command Center
Dataset Key: cst-phc-gmfmfg
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              ,
ORGANIZATION_ID            ,
TRANSACTION_QUANTITY       ,
TRANSACTION_UOM            ,
TRANSACTION_DATE           ,
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"))
) x
where
2=2