WIE_INV_MAT_RESERVATIONS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WIE
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
DEMAND_SOURCE_HEADER_ID ORGANIZATION_ID MATERIAL_RESERVED |
問合せ
| SQL_Statement |
|---|
|
SELECT DISTINCT DEMAND_SOURCE_HEADER_ID, ORGANIZATION_ID, 'Y' AS MATERIAL_RESERVED FROM INV_RESERVATIONS WHERE DEMAND_SOURCE_TYPE_ID=5 |