VIEW: APPS.MSC_REGION_ITEM_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT mria.rowid, mria.Simulation_set_id, mria.Plan_id, mria.Sr_instance_id, mria.Organization_Id, mria.Inventory_item_id, msi.item_name, mria.Region_id, mria.Region_instance_id, mria.Region, mic.Sr_Category_Id, mic.Category_Set_Id, mic.Category_Name, msi.buyer_name, mic.Description, mfr1.forecast_rule_name , mfr2.forecast_rule_name , mria.Life_Time_Buy_Date , mria.End_Of_Life_Date , mria.Avg_Demand_Beyond_Ph , mria.Avg_Returns_Beyond_Ph , mria.Return_Forecast_Time_Fence , mria.Average_Daily_Demand , mria.Defective_Item_Cost , MRIA.BASIS_AVG_DAILY_DEMAND , mria.Std_Deviation_For_demand , mria.Mean_Inter_Arrival , mria.Std_Deviation_Inter_arrival , mria.interarrival_dist_method , mria.updated_columns_count , 'Yes' , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , null , null , null , null , to_number(null) , null , null , null , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , to_number(null) , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , null , null , null , null , null , null , null , null , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , to_number(null) , null , null , to_number(null) , null , to_number(null) , to_number(null) , to_number(null) , to_number(null) , null , null , null , to_number(null) , to_number(null), msc_get_name.lookup_meaning('MSC_INTERMITTENT_DEMAND',mria.intermittent_demand), msc_get_name.lookup_meaning('SYS_YES_NO',mria.rounding_control_type), to_number(null), null, to_number(null), to_number(null), null, to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), null, null, to_number(null), to_number(null), to_number(null), null, null, to_number(null), to_number(null), to_number(null), null, null, to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null) from msc_item_attributes mria, msc_item_categories mic, msc_system_items msi, msc_forecast_rules mfr1, msc_forecast_rules mfr2 WHERE mria.plan_id = -1 and mria.region_id is not null and mria.plan_id = msi.plan_id and mria.sr_instance_id = msi.sr_instance_id and mria.inventory_item_id = msi.inventory_item_id and mria.organization_id = msi.organization_id and mria.sr_instance_id = mic.sr_instance_id and mria.inventory_item_id = mic.inventory_item_id and mria.organization_id = mic.organization_id and mria.Forecast_Rule_For_DemandS = mfr1.forecast_rule_id (+) and mria.Forecast_Rule_For_Returns = mfr2.forecast_rule_id(+)

View Text - HTML Formatted

SELECT MRIA.ROWID
, MRIA.SIMULATION_SET_ID
, MRIA.PLAN_ID
, MRIA.SR_INSTANCE_ID
, MRIA.ORGANIZATION_ID
, MRIA.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MRIA.REGION_ID
, MRIA.REGION_INSTANCE_ID
, MRIA.REGION
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MSI.BUYER_NAME
, MIC.DESCRIPTION
, MFR1.FORECAST_RULE_NAME
, MFR2.FORECAST_RULE_NAME
, MRIA.LIFE_TIME_BUY_DATE
, MRIA.END_OF_LIFE_DATE
, MRIA.AVG_DEMAND_BEYOND_PH
, MRIA.AVG_RETURNS_BEYOND_PH
, MRIA.RETURN_FORECAST_TIME_FENCE
, MRIA.AVERAGE_DAILY_DEMAND
, MRIA.DEFECTIVE_ITEM_COST
, MRIA.BASIS_AVG_DAILY_DEMAND
, MRIA.STD_DEVIATION_FOR_DEMAND
, MRIA.MEAN_INTER_ARRIVAL
, MRIA.STD_DEVIATION_INTER_ARRIVAL
, MRIA.INTERARRIVAL_DIST_METHOD
, MRIA.UPDATED_COLUMNS_COUNT
, 'YES'
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_INTERMITTENT_DEMAND'
, MRIA.INTERMITTENT_DEMAND)
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, MRIA.ROUNDING_CONTROL_TYPE)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MSC_ITEM_ATTRIBUTES MRIA
, MSC_ITEM_CATEGORIES MIC
, MSC_SYSTEM_ITEMS MSI
, MSC_FORECAST_RULES MFR1
, MSC_FORECAST_RULES MFR2
WHERE MRIA.PLAN_ID = -1
AND MRIA.REGION_ID IS NOT NULL
AND MRIA.PLAN_ID = MSI.PLAN_ID
AND MRIA.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MRIA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MRIA.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MRIA.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MRIA.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MRIA.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MRIA.FORECAST_RULE_FOR_DEMANDS = MFR1.FORECAST_RULE_ID (+)
AND MRIA.FORECAST_RULE_FOR_RETURNS = MFR2.FORECAST_RULE_ID(+)