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
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
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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, 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 |
|
LOV |