eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MSC.MSC_REGION_ITEM_ATTRIBUTES#

Source

View Text - Preformatted


select SIMULATION_SET_ID SIMULATION_SET_ID, PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REGION_ID REGION_ID, REGION_INSTANCE_ID REGION_INSTANCE_ID, REGION REGION, FORECAST_RULE_FOR_DEMANDS FORECAST_RULE_FOR_DEMANDS, FORECAST_RULE_FOR_RETURNS FORECAST_RULE_FOR_RETURNS, END_OF_LIFE_DATE END_OF_LIFE_DATE, LIFE_TIME_BUY_DATE LIFE_TIME_BUY_DATE, AVG_DEMAND_BEYOND_PH AVG_DEMAND_BEYOND_PH, AVG_RETURNS_BEYOND_PH AVG_RETURNS_BEYOND_PH, RETURN_FORECAST_TIME_FENCE RETURN_FORECAST_TIME_FENCE, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND, DEFECTIVE_ITEM_COST DEFECTIVE_ITEM_COST, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND, STD_DEVIATION_FOR_DEMAND STD_DEVIATION_FOR_DEMAND, MEAN_INTER_ARRIVAL MEAN_INTER_ARRIVAL, STD_DEVIATION_INTER_ARRIVAL STD_DEVIATION_INTER_ARRIVAL, STANDARD_DEVIATION STANDARD_DEVIATION, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION, INTERARRIVAL_DIST_METHOD INTERARRIVAL_DIST_METHOD, UPDATED_COLUMNS_COUNT UPDATED_COLUMNS_COUNT, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, USER_ATTRIBUTE6 USER_ATTRIBUTE6, USER_ATTRIBUTE7 USER_ATTRIBUTE7, USER_ATTRIBUTE8 USER_ATTRIBUTE8, USER_ATTRIBUTE9 USER_ATTRIBUTE9, USER_ATTRIBUTE10 USER_ATTRIBUTE10, USER_ATTRIBUTE11 USER_ATTRIBUTE11, USER_ATTRIBUTE12 USER_ATTRIBUTE12, USER_ATTRIBUTE13 USER_ATTRIBUTE13, USER_ATTRIBUTE14 USER_ATTRIBUTE14, USER_ATTRIBUTE15 USER_ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "MSC"."MSC_REGION_ITEM_ATTRIBUTES"

View Text - HTML Formatted

SELECT SIMULATION_SET_ID SIMULATION_SET_ID
, PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REGION_ID REGION_ID
, REGION_INSTANCE_ID REGION_INSTANCE_ID
, REGION REGION
, FORECAST_RULE_FOR_DEMANDS FORECAST_RULE_FOR_DEMANDS
, FORECAST_RULE_FOR_RETURNS FORECAST_RULE_FOR_RETURNS
, END_OF_LIFE_DATE END_OF_LIFE_DATE
, LIFE_TIME_BUY_DATE LIFE_TIME_BUY_DATE
, AVG_DEMAND_BEYOND_PH AVG_DEMAND_BEYOND_PH
, AVG_RETURNS_BEYOND_PH AVG_RETURNS_BEYOND_PH
, RETURN_FORECAST_TIME_FENCE RETURN_FORECAST_TIME_FENCE
, AVERAGE_DAILY_DEMAND AVERAGE_DAILY_DEMAND
, DEFECTIVE_ITEM_COST DEFECTIVE_ITEM_COST
, BASIS_AVG_DAILY_DEMAND BASIS_AVG_DAILY_DEMAND
, STD_DEVIATION_FOR_DEMAND STD_DEVIATION_FOR_DEMAND
, MEAN_INTER_ARRIVAL MEAN_INTER_ARRIVAL
, STD_DEVIATION_INTER_ARRIVAL STD_DEVIATION_INTER_ARRIVAL
, STANDARD_DEVIATION STANDARD_DEVIATION
, COEFFICIENT_OF_VARIATION COEFFICIENT_OF_VARIATION
, INTERARRIVAL_DIST_METHOD INTERARRIVAL_DIST_METHOD
, UPDATED_COLUMNS_COUNT UPDATED_COLUMNS_COUNT
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, USER_ATTRIBUTE6 USER_ATTRIBUTE6
, USER_ATTRIBUTE7 USER_ATTRIBUTE7
, USER_ATTRIBUTE8 USER_ATTRIBUTE8
, USER_ATTRIBUTE9 USER_ATTRIBUTE9
, USER_ATTRIBUTE10 USER_ATTRIBUTE10
, USER_ATTRIBUTE11 USER_ATTRIBUTE11
, USER_ATTRIBUTE12 USER_ATTRIBUTE12
, USER_ATTRIBUTE13 USER_ATTRIBUTE13
, USER_ATTRIBUTE14 USER_ATTRIBUTE14
, USER_ATTRIBUTE15 USER_ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "MSC"."MSC_REGION_ITEM_ATTRIBUTES"