ECC Cost Management, Manufacturing (Discrete)

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, Group Id, Last Update Date, Creation Date ...
Imported from Enterprise Command Center
Dataset Key: cst-phc-mfg-dis
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,
GROUP_ID,
LAST_UPDATE_DATE,
CREATION_DATE,
INVENTORY_ITEM_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_YEAR,
PERIOD_NUM,
TASK_NAME,
PROJECT_NAME,
ORGANIZATION_ID,
TRANSACTION_TYPE,
WIP_ENTITY_NAME,
PO_NUMBER,
TRANSACTION_QUANTITY,
TRANSACTION_UOM,
PRIMARY_QUANTITY,
TRANSACTION_DATE,
TRANSACTION_MONTH,
ACCT_PERIOD_ID,
REFERENCE,
REASON_NAME,
ENCUMBRANCE_CCID,
ENCUMBRANCE_AMOUNT,
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
DEPARTMENT_CODE,
OPERATION_SEQ_NUM,
RCV_TRANSACTION_ID,
MOVE_TRANSACTION_ID,
COMPLETION_TRANSACTION_ID,
TASK_ID,
PROJECT_ID,
ERROR,
OVERCOMPLETION_PRIMARY_QTY,
OVERCOMPLETION_TXN_ID,
EMPLOYEE_ID,
WIP_ENTITY_ID,
REPETITIVE_SCHEDULE_ID,
RESOURCE_SEQ_NUM,
RESOURCE_ID,
RESOURCE_CODE,
PROCESS_PHASE,
ENTITY_TYPE,
LINE_ID,
LINE_CODE,
DEPARTMENT_ID,
EMPLOYEE_NUM,
RESOURCE_TYPE,
USAGE_RATE_OR_AMOUNT,
BASIS_TYPE,
AUTOCHARGE_TYPE,
STANDARD_RATE_FLAG,
PRIMARY_UOM,
PRIMARY_UOM_CLASS,
ACTUAL_RESOURCE_RATE,
CURRENCY_ACTUAL_RESOURCE_RATE,
ACTIVITY_ID,
ACTIVITY_NAME,
REASON_ID,
PO_LINE_ID,
RECEIVING_ACCOUNT_ID,
PHANTOM_FLAG,
CHARGE_DEPARTMENT_ID,
INSTANCE_ID,
ENCUMBRANCE_TYPE_ID,
ENCUMBRANCE_QUANTITY,
FM_OPERATION_SEQ_NUM,
FM_OPERATION_CODE,
FM_DEPARTMENT_ID,
FM_DEPARTMENT_CODE,
FM_INTRAOPERATION_STEP_TYPE,
TO_OPERATION_SEQ_NUM,
TO_OPERATION_CODE,
TO_DEPARTMENT_ID,
TO_DEPARTMENT_CODE,
TO_INTRAOPERATION_STEP_TYPE,
SCRAP_ACCOUNT_ID,
QA_COLLECTION_ID,
KANBAN_CARD_ID,
OVERCOMPLETION_TXN_QTY,
PROCESSING_ORDER,
BATCH_ID,
COMPLETED_INSTRUCTIONS,
TO_INTEROP_STEP_TYPE,
FROM_INTEROP_STEP_TYPE,
NEW_WIP_ENTITY_NAME,
PRIMARY_SCRAP_QUANTITY,
SCRAP_QUANTITY,
SCRAP_AT_OPERATION_FLAG,
INTERNAL_GROUP_ID,
INTERNAL_SCRAP_TXN_ID,
SERIAL_START_FLAG,
INTERFACE_ID,
HEADER_ID,
PERIOD_STATUS,
LANGUAGE,
REQUEST_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
CONCURRENT_PROGRAM_NAME,
TXN_PROCESSING_STATUS,
TXN_PROCESSING_STATUS_CODE,
PERIOD_STATUS_CODE         ,
PERIOD_STATUS_CODE COSTING_PERIOD_STATUS_CODE ,
PERIOD_STATUS COSTING_PERIOD_STATUS,
ERROR_COLUMN,
ERROR_MESSAGE
FROM CST_ECC_PHC_MFG_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(ITEM_DESCRIPTION) as ITEM_DESCRIPTION,
                                              max(ORGANIZATION_NAME) as ORGANIZATION_NAME,
                                              max(OPERATING_UNIT) as OPERATING_UNIT,
                                              max(TRANSACTION_TYPE) as TRANSACTION_TYPE,
                                              max(RESOURCE_TYPE) AS RESOURCE_TYPE,
                                              max(AUTOCHARGE_TYPE) as AUTOCHARGE_TYPE,
                                              max(ENTITY_TYPE) as ENTITY_TYPE,
                                              max(BASIS_TYPE) as BASIS_TYPE,
                                              max(STANDARD_RATE_FLAG) as STANDARD_RATE_FLAG,
											  max(CONCURRENT_PROGRAM_NAME) as CONCURRENT_PROGRAM_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