WIE_WO_OP_MATERIALS_RSV_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
ORGANIZATION_ID WORK_ORDER_ID WO_OPERATION_ID INVENTORY_ITEM_ID ITEM_REVISION REQUIRED_DATE QUANTITY ISSUED_QUANTITY UOM_CODE ENFORCE_INT_REQUIREMENTS EXTENDED_QUANTITY QUANTITY_SIGN

Query

SQL_Statement

SELECT mat.organization_id, mat.work_order_id, mat.wo_operation_id, mat.inventory_item_id, mat.item_revision, MIN(mat.required_date) required_date, SUM(mat.quantity) quantity, SUM(mat.issued_quantity) issued_quantity, mat.uom_code, mat.enforce_int_requirements, SUM(mat.extended_quantity) extended_quantity, sign(quantity) quantity_sign FROM wie_wo_operation_materials mat WHERE material_type IN ( 'COMPONENT', 'ASSEMBLY_COMPONENT' ) AND supply_type IN ( 1, 2, 3 ) GROUP BY mat.organization_id, mat.work_order_id, mat.wo_operation_id, mat.inventory_item_id, mat.item_revision, mat.uom_code, sign(quantity), mat.enforce_int_requirements