ECC Cost Management, Manufacturing (Discrete)

Description
Categories: Enterprise Command Center
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
Run ECC Cost Management, Manufacturing (Discrete) 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,
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
Blitz Report™