機械翻訳について

WIE_ELIGBL_MAT_RESERVATIONS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: WIE

• オブジェクト・タイプ: VIEW

列

名前
WORK_ORDER_ID ORGANIZATION_ID ELIGIBLE_FOR_RESERVATION

問合せ

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)