ECC Cost Management, Manufacturing (Process)

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, Organization Id ...
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
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,
                       TRANSACTION_MONTH,
                       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
Parameter Name SQL text Validation
Organization Code
x.organization_code=:organization_code
LOV