MSC_SAFETY_STOCKS_V

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name

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

Query

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 /* Read data from MSC_SAFETY_STOCKS only if new table MSC_SAFETY_STOCK_TXNS is empty. We can remove this SELECT in future release, may be 21A. Check Bug#30232513 for more details. */ 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