MSC_SAFETY_STOCKS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: FUSION
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PLAN_ID TRANSACTION_ID ORGANIZATION_ID INVENTORY_ITEM_ID PERIOD_START_DATE SAFETY_STOCK_QUANTITY REFRESH_NUMBER GLOBAL_ATTRIBUTE_NUMBER11 GLOBAL_ATTRIBUTE_NUMBER12 GLOBAL_ATTRIBUTE_NUMBER13 GLOBAL_ATTRIBUTE_NUMBER14 GLOBAL_ATTRIBUTE_NUMBER15 GLOBAL_ATTRIBUTE_NUMBER16 GLOBAL_ATTRIBUTE_NUMBER17 GLOBAL_ATTRIBUTE_NUMBER18 GLOBAL_ATTRIBUTE_NUMBER19 GLOBAL_ATTRIBUTE_NUMBER20 GLOBAL_ATTRIBUTE_NUMBER21 GLOBAL_ATTRIBUTE_NUMBER22 GLOBAL_ATTRIBUTE_NUMBER23 GLOBAL_ATTRIBUTE_NUMBER24 GLOBAL_ATTRIBUTE_NUMBER25 LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT PLAN_ID, TRANSACTION_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, PERIOD_START_DATE, SAFETY_STOCK_QUANTITY, REFRESH_NUMBER, GLOBAL_ATTRIBUTE_NUMBER11, GLOBAL_ATTRIBUTE_NUMBER12, GLOBAL_ATTRIBUTE_NUMBER13, GLOBAL_ATTRIBUTE_NUMBER14, GLOBAL_ATTRIBUTE_NUMBER15, GLOBAL_ATTRIBUTE_NUMBER16, GLOBAL_ATTRIBUTE_NUMBER17, GLOBAL_ATTRIBUTE_NUMBER18, GLOBAL_ATTRIBUTE_NUMBER19, GLOBAL_ATTRIBUTE_NUMBER20, GLOBAL_ATTRIBUTE_NUMBER21, GLOBAL_ATTRIBUTE_NUMBER22, GLOBAL_ATTRIBUTE_NUMBER23, GLOBAL_ATTRIBUTE_NUMBER24, GLOBAL_ATTRIBUTE_NUMBER25, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN FROM MSC_SAFETY_STOCK_TXNS UNION ALL /*新しい表MSC_SAFETY_STOCK_TXNSが空の場合にのみ、MSC_SAFETY_STOCKSからデータを読み取ります。 これを削除できます 将来のリリースではSELECTは21Aになる可能性があります。 詳細については、Bug#30232513を確認してください。 */ SELECT PLAN_ID, NULL TRANSACTION_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, PERIOD_START_DATE, SAFETY_STOCK_QUANTITY, REFRESH_NUMBER, GLOBAL_ATTRIBUTE_NUMBER11, GLOBAL_ATTRIBUTE_NUMBER12, NULL GLOBAL_ATTRIBUTE_NUMBER13, NULL GLOBAL_ATTRIBUTE_NUMBER14, NULL GLOBAL_ATTRIBUTE_NUMBER15, NULL GLOBAL_ATTRIBUTE_NUMBER16, NULL GLOBAL_ATTRIBUTE_NUMBER17, NULL GLOBAL_ATTRIBUTE_NUMBER18, NULL GLOBAL_ATTRIBUTE_NUMBER19, NULL GLOBAL_ATTRIBUTE_NUMBER20, NULL GLOBAL_ATTRIBUTE_NUMBER21, NULL GLOBAL_ATTRIBUTE_NUMBER22, NULL GLOBAL_ATTRIBUTE_NUMBER23, NULL GLOBAL_ATTRIBUTE_NUMBER24, NULL GLOBAL_ATTRIBUTE_NUMBER25, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN FROM MSC_SAFETY_STOCKS |