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.

APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_DEMANDS

Line 111: -- MSC_DEMANDS and MSC_SUPPLIES

107: l_plan_type NUMBER := 1;
108:
109: -- --------------------------------------------
110: -- This cursor selects the snapshot activity in
111: -- MSC_DEMANDS and MSC_SUPPLIES
112: -- for the items per organizatio for a plan..
113: -- --------------------------------------------
114:
115: -- Ship To Values

Line 148: msc_demands md

144: md.using_assembly_demand_date old_date,
145: sum(md.using_requirement_quantity) new_quantity,
146: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
147: FROM msc_form_query list,
148: msc_demands md
149: WHERE md.plan_id = list.number4
150: AND md.inventory_item_id = list.number1
151: AND md.organization_id = list.number2
152: AND md.sr_instance_id = list.number3

Line 242: msc_demands md

238: md.using_assembly_demand_date old_date,
239: sum(nvl(md.using_requirement_quantity,0)) new_quantity,
240: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
241: FROM msc_form_query list,
242: msc_demands md
243: WHERE md.plan_id = list.number4
244: AND md.inventory_item_id = list.number1
245: AND md.organization_id = list.number2
246: AND md.sr_instance_id = list.number3

Line 294: msc_demands md

290: md.using_assembly_demand_date old_date,
291: sum(nvl(md.using_requirement_quantity,0)) new_quantity,
292: sum(nvl(md.UNMET_QUANTITY,0)) unmet_quantity
293: FROM msc_form_query list,
294: msc_demands md
295: WHERE md.plan_id = list.number4
296: AND md.original_item_id = list.number1
297: AND md.organization_id = list.number2
298: AND md.sr_instance_id = list.number3

Line 865: msc_demands md

861:
862: cursor local_forecasting(p_org number, p_inst number, p_item number) is
863: select mde.update_type
864: from msc_designators mde,
865: msc_demands md
866: where md.plan_id = p_plan_id
867: and md.organization_id = p_org
868: and md.sr_instance_id = p_inst
869: and md.inventory_item_id = p_item

Line 1124: ' FROM msc_forecast_updates mfu, msc_demands md'||

1120: IF p_rowtype = CONSUMED THEN -- Forecast Consumed Row
1121:
1122: sql_stmt := sql_stmt ||
1123: ' md.demand_id '||
1124: ' FROM msc_forecast_updates mfu, msc_demands md'||
1125: ' WHERE mfu.plan_id = :p_plan_id' ||
1126: ' AND mfu.sr_instance_id = :p_inst_id'||
1127: ' and mfu.organization_id =:p_org_id '||
1128: ' and mfu.inventory_item_id = :p_item_id' ||

Line 1139: ' FROM msc_demands md,'||

1135: FCST_SUBS_IN, SO_SUBS_IN) THEN
1136: if p_org_id = -1 then
1137: sql_stmt := sql_stmt ||
1138: ' md2.demand_id '||
1139: ' FROM msc_demands md,'||
1140: ' msc_demands md2 '||
1141: ' WHERE md.plan_id = :p_plan_id' ||
1142: ' AND md.sr_instance_id = :p_inst_id'||
1143: ' and md.organization_id =:p_org_id '||

Line 1140: ' msc_demands md2 '||

1136: if p_org_id = -1 then
1137: sql_stmt := sql_stmt ||
1138: ' md2.demand_id '||
1139: ' FROM msc_demands md,'||
1140: ' msc_demands md2 '||
1141: ' WHERE md.plan_id = :p_plan_id' ||
1142: ' AND md.sr_instance_id = :p_inst_id'||
1143: ' and md.organization_id =:p_org_id '||
1144: ' and trunc(md.using_assembly_demand_date) BETWEEN '''||

Line 1153: ' FROM msc_demands md'||

1149: else
1150:
1151: sql_stmt := sql_stmt ||
1152: ' md.demand_id ' ||
1153: ' FROM msc_demands md'||
1154: ' WHERE md.plan_id = :p_plan_id' ||
1155: ' AND md.sr_instance_id = :p_inst_id'||
1156: ' and md.organization_id =:p_org_id '||
1157: ' and trunc(md.using_assembly_demand_date) BETWEEN '''||

Line 1184: ' FROM msc_demands md,'||

1180: ELSIF p_rowtype in (CURRENT, SO_CURRENT) THEN -- Current Row
1181: IF p_org_id = -1 then
1182: sql_stmt := sql_stmt ||
1183: ' orig_md.demand_id ' ||
1184: ' FROM msc_demands md,'||
1185: ' msc_demands orig_md'||
1186: ' WHERE md.plan_id = :p_plan_id' ||
1187: ' and md.sr_instance_id = :p_inst_id' ||
1188: ' and md.organization_id =:p_org_id '||

Line 1185: ' msc_demands orig_md'||

1181: IF p_org_id = -1 then
1182: sql_stmt := sql_stmt ||
1183: ' orig_md.demand_id ' ||
1184: ' FROM msc_demands md,'||
1185: ' msc_demands orig_md'||
1186: ' WHERE md.plan_id = :p_plan_id' ||
1187: ' and md.sr_instance_id = :p_inst_id' ||
1188: ' and md.organization_id =:p_org_id '||
1189: ' and md.inventory_item_id = :p_item_id' ||

Line 1197: ' FROM msc_demands md'||

1193: ' and md.demand_id = nvl(orig_md.original_demand_id, orig_md.demand_id) ';
1194: ELSE -- IF p_org_id <> -1 then
1195: sql_stmt := sql_stmt ||
1196: ' md.demand_id ' ||
1197: ' FROM msc_demands md'||
1198: ' WHERE md.plan_id = :p_plan_id' ||
1199: ' and md.sr_instance_id = :p_inst_id' ||
1200: ' and md.organization_id =:p_org_id '||
1201: ' and md.inventory_item_id = :p_item_id' ||

Line 1260: from msc_demands md

1256: CURSOR ship_to_c IS
1257: select to_char(md.customer_id),
1258: to_char(md.customer_site_id),
1259: to_char(md.zone_id)
1260: from msc_demands md
1261: where plan_id = p_plan_id
1262: and demand_id = p_sales_order_id;
1263:
1264: v_customer varchar2(100);