WIE_PROD_EXECUTION_PARAMS_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
ORGANIZATION_ID WORK_CENTER_ID QUANTITY_UOM_CODE PLAN_ADHERENCE_TARGET_PERCENT OEE_TARGET_PERCENT AVAILABILITY_TARGET_PERCENT PERFORMANCE_TARGET_PERCENT QUALITY_TARGET_PERCENT PERF_LOSS_THRESHOLD_LIMIT OPERATOR_ASSIGNMENT_CODE WO_OPERATION_ASSIGNMENT_CODE

Query

SQL_Statement

SELECT wcb.organization_id AS organization_id, wcb.work_center_id AS work_center_id, CASE WHEN NVL(wpe.override_uom_flag, 'N') = 'Y' THEN COALESCE(wce.quantity_uom_code, wpe.quantity_uom_code) ELSE wpe.quantity_uom_code END AS quantity_uom_code, NVL(wpe.plan_adherence_target_percent,100) AS plan_adherence_target_percent, NVL(wpe.oee_target_percent,100) AS oee_target_percent, NVL(wpe.availability_target_percent,100) AS availability_target_percent, NVL(wpe.performance_target_percent,100) AS performance_target_percent, NVL(wpe.quality_target_percent,100) AS quality_target_percent, NVL(wpe.perf_loss_threshold_limit,120) AS perf_loss_threshold_limit, NVL(wpe.operator_assignment_code,'NOT_ENFORCED') AS operator_assignment_code, NVL(wpe.wo_operation_assignment_code ,'NOT_ENFORCED') AS wo_operation_assignment_code FROM wis_work_centers_b wcb LEFT JOIN wie_prod_execution_params wpe ON wcb.organization_id = wpe.organization_id LEFT JOIN wie_prod_exec_prm_wc_overrides wce ON (wcb.work_center_id = wce.work_center_id AND wpe.organization_id = wce.organization_id)