WIE_WO_RESERVABLE_COMPS_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
WORK_ORDER_NUMBER WORK_ORDER_ID ORGANIZATION_ID OPERATION_SEQ_NUMBER WO_OPERATION_ID ASSEMBLY_ITEM ASSEMBLY_ITEM_ID COMPONENT_ITEM COMPONENT_ITEM_ID REQUIRED_DATE DEMAND_PROJECT_NUMBER DEMAND_PROJECT_ID DEMAND_TASK_NUMBER DEMAND_TASK_ID REQUESTED_QUANTITY DEMAND_UOM WO_SYSTEM_STATUS_CODE

Query

SQL_Statement

SELECT WO.WORK_ORDER_NUMBER, WO.WORK_ORDER_ID, WO.ORGANIZATION_ID, WOOP.OPERATION_SEQ_NUMBER, WOOP.WO_OPERATION_ID, EGP1.ITEM_NUMBER "ASSEMBLY_ITEM", WO.INVENTORY_ITEM_ID "ASSEMBLY_ITEM_ID", EGP2.ITEM_NUMBER "COMPONENT_ITEM", WOOM.INVENTORY_ITEM_ID "COMPONENT_ITEM_ID", WOOM.REQUIRED_DATE, WO.PJC_PROJECT_NUMBER "DEMAND_PROJECT_NUMBER", WO.PJC_PROJECT_ID "DEMAND_PROJECT_ID", WO.PJC_TASK_NUMBER "DEMAND_TASK_NUMBER", WO.PJC_TASK_ID "DEMAND_TASK_ID", CASE WHEN WOOM.QUANTITY-NVL(WOOM.ISSUED_QUANTITY,0) > 0 THEN INV_CONVERT.INV_UM_CONVERT( WOOM.INVENTORY_ITEM_ID, NULL, WOOM.ORGANIZATION_ID,NULL,(WOOM.QUANTITY-NVL(WOOM.ISSUED_QUANTITY,0)), WOOM.UOM_CODE, EGP2.PRIMARY_UOM_CODE, NULL, NULL ) ELSE 0 END AS "REQUESTED_QUANTITY", EGP2.PRIMARY_UOM_CODE "DEMAND_UOM", ST.WO_SYSTEM_STATUS_CODE FROM WIE_WORK_ORDERS_B WO, WIE_WO_OPERATIONS_B WOOP, WIE_WO_OPERATION_MATERIALS WOOM, EGP_SYSTEM_ITEMS_VL EGP1, EGP_SYSTEM_ITEMS_VL EGP2, WIE_WO_STATUSES_B ST WHERE WO.WORK_ORDER_ID = WOOP.WORK_ORDER_ID AND WO.WORK_ORDER_ID = WOOM.WORK_ORDER_ID AND WOOP.WO_OPERATION_ID = WOOM.WO_OPERATION_ID AND EGP1.INVENTORY_ITEM_ID = WO.INVENTORY_ITEM_ID AND EGP1.ORGANIZATION_ID = WO.ORGANIZATION_ID AND EGP2.INVENTORY_ITEM_ID = WOOM.INVENTORY_ITEM_ID AND EGP2.ORGANIZATION_ID = WOOM.ORGANIZATION_ID AND WO.WORK_ORDER_STATUS_ID = ST.WO_STATUS_ID AND ST.WO_SYSTEM_STATUS_CODE IN ('UNRELEASED','RELEASED') AND WO.ORDER_LESS_FLAG = 'N' AND WO.CONTRACT_MFG_FLAG = 'N' AND WOOM.SUPPLY_TYPE IN ('1','2','3') AND WOOM.QUANTITY > 0 AND WOOM.MATERIAL_TYPE IN ('COMPONENT','ASSEMBLY_COMPONENT')