1. Tables and Views for SCM
  2. WIE_ELIGBL_MAT_RESERVATIONS_V

WIE_ELIGBL_MAT_RESERVATIONS_V

Details

  • Schema: FUSION

  • Object owner: WIE

  • Object type: VIEW

Columns

Name

WORK_ORDER_ID

ORGANIZATION_ID

ELIGIBLE_FOR_RESERVATION

Query

SQL_Statement

SELECT WO.WORK_ORDER_ID AS WORK_ORDER_ID,

WO.ORGANIZATION_ID AS ORGANIZATION_ID,

'Y' AS ELIGIBLE_FOR_RESERVATION

FROM WIE_WORK_ORDERS_B WO

WHERE EXISTS (SELECT 1 FROM WIE_WO_OPERATION_MATERIALS MAT, EGP_SYSTEM_ITEMS_VL ITEM

WHERE MAT.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID

AND MAT.WORK_ORDER_ID = WO.WORK_ORDER_ID

AND MAT.ORGANIZATION_ID = ITEM.ORGANIZATION_ID

AND MAT.WO_OPERATION_ID IS NOT NULL AND MAT.QUANTITY > 0 AND MAT.SUPPLY_TYPE IN ('1', '2', '3')

AND MAT.MATERIAL_TYPE IN ('COMPONENT', 'ASSEMBLY_COMPONENT') AND ITEM.RESERVABLE_TYPE = 1)