ECC Cost Management, Maintenance
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: cst-phc-eam
Query Procedure: CST_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CST_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Dataset Key: cst-phc-eam
Query Procedure: CST_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CST_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run
ECC Cost Management, Maintenance 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, WIP_ENTITY_ID, WIP_ENTITY_NAME, ORGANIZATION_ID, LAST_UPDATE_DATE, CREATION_DATE, SOURCE_LINE_ID, SOURCE_CODE, DESCRIPTION, PRIMARY_ITEM_ID, JOB_TYPE, WIP_SUPPLY_TYPE, CLASS_CODE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, MATERIAL_VARIANCE_ACCOUNT, RESOURCE_VARIANCE_ACCOUNT, OUTSIDE_PROC_VARIANCE_ACCOUNT, STD_COST_ADJUSTMENT_ACCOUNT, OVERHEAD_ACCOUNT, OVERHEAD_VARIANCE_ACCOUNT, SCHEDULED_START_DATE, DATE_RELEASED, SCHEDULED_COMPLETION_DATE, DATE_COMPLETED, DATE_CLOSED, START_QUANTITY, QUANTITY_COMPLETED, QUANTITY_SCRAPPED, NET_QUANTITY, BOM_REFERENCE_ID, ROUTING_REFERENCE_ID, COMMON_BOM_SEQUENCE_ID, COMMON_ROUTING_SEQUENCE_ID, BOM_REVISION, ROUTING_REVISION, LOT_NUMBER, ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR, COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID, MPS_SCHEDULED_COMPLETION_DATE, MPS_NET_QUANTITY, DEMAND_CLASS, SCHEDULE_GROUP_ID, BUILD_SEQUENCE, LINE_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, KANBAN_CARD_ID, OVERCOMPLETION_TOLERANCE_TYPE, OVERCOMPLETION_TOLERANCE_VALUE, END_ITEM_UNIT_NUMBER, PRIORITY, DUE_DATE, EST_SCRAP_ACCOUNT, EST_SCRAP_VAR_ACCOUNT, EST_SCRAP_PRIOR_QTY, DUE_DATE_PENALTY, DUE_DATE_TOLERANCE, PARENT_WIP_ENTITY_ID, ASSET_NUMBER, ASSET_GROUP_ID, REBUILD_ITEM_ID, REBUILD_SERIAL_NUMBER, MANUAL_REBUILD_FLAG, SHUTDOWN_TYPE, ESTIMATION_STATUS, REQUESTED_START_DATE, NOTIFICATION_REQUIRED, WORK_ORDER_TYPE, OWNING_DEPARTMENT, ACTIVITY_TYPE, ACTIVITY_CAUSE, TAGOUT_REQUIRED, PLAN_MAINTENANCE, PM_SCHEDULE_ID, LAST_ESTIMATION_DATE, LAST_ESTIMATION_REQ_ID, ACTIVITY_SOURCE, MAINTENANCE_OBJECT_ID, MAINTENANCE_OBJECT_TYPE, MAINTENANCE_OBJECT_SOURCE, MATERIAL_ISSUE_BY_MO, SCHEDULING_REQUEST_ID, ISSUE_ZERO_COST_FLAG, EAM_LINEAR_LOCATION_ID, ACTUAL_START_DATE, EXPECTED_HOLD_RELEASE_DATE, EXPEDITED, PERIOD_STATUS, LANGUAGE, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_NAME, PERIOD_STATUS_CODE , PERIOD_STATUS_CODE COSTING_PERIOD_STATUS_CODE , PERIOD_STATUS COSTING_PERIOD_STATUS FROM CST_ECC_PHC_EAM_WO_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(ITEM_DESCRIPTION) as ITEM_DESCRIPTION, max(ORGANIZATION_NAME) as ORGANIZATION_NAME, max(CONCURRENT_PROGRAM_NAME) as CONCURRENT_PROGRAM_NAME, max(JOB_TYPE) as JOB_TYPE, max(WIP_SUPPLY_TYPE) as WIP_SUPPLY_TYPE, max(OPERATING_UNIT) as OPERATING_UNIT, 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 |