APPS.MSC_ATP_PEG dependencies on MSC_FORECAST_UPDATES

Line 123: -- This record is for holding data obtained from msc_forecast_updates

119: atf_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
120: product_family_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
121: );
122:
123: -- This record is for holding data obtained from msc_forecast_updates
124: -- and msc_system_items.
125: TYPE ATP_Fcst_Cons_Typ is RECORD (
126: plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
127: sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 1282: FROM msc_forecast_updates fcst, msc_system_items msi

1278: x_fcst_data_tab.variable_lt,
1279: -- Bug 3701093, flag overconsumption
1280: x_fcst_data_tab.cons_config_mod_flag, l_item_typ
1281: -- End Bug 3417410 Collect into return record.
1282: FROM msc_forecast_updates fcst, msc_system_items msi
1283: WHERE fcst.sr_instance_id = atp_peg_tab.sr_instance_id(k)
1284: AND fcst.plan_id = atp_peg_tab.plan_id(k)
1285: AND (fcst.organization_id = atp_peg_tab.organization_id(k)
1286: OR fcst.organization_id = -1)

Line 1380: FROM msc_forecast_updates fcst,

1376: msi.fixed_lead_time,
1377: msi.variable_lead_time,
1378: 1,
1379: decode(fcst.inventory_item_id, fcst.parent_item_id, 0, atp_peg_tab.base_item_id(k), 1, fcst.inventory_item_id)
1380: FROM msc_forecast_updates fcst,
1381: msc_system_items msi
1382: WHERE fcst.sr_instance_id = atp_peg_tab.sr_instance_id(k)
1383: AND fcst.plan_id = atp_peg_tab.plan_id(k)
1384: AND(fcst.organization_id = atp_peg_tab.organization_id(k) OR fcst.organization_id = -1)

Line 1414: FROM msc_forecast_updates fcst,

1410: msi.fixed_lead_time,
1411: msi.variable_lead_time,
1412: 1,
1413: decode(fcst.inventory_item_id, fcst.parent_item_id, 0, atp_peg_tab.base_item_id(k), 1, fcst.inventory_item_id)
1414: FROM msc_forecast_updates fcst,
1415: msc_system_items msi
1416: WHERE fcst.sr_instance_id = atp_peg_tab.sr_instance_id(k)
1417: AND fcst.plan_id = atp_peg_tab.plan_id(k)
1418: AND(fcst.organization_id = atp_peg_tab.organization_id(k) OR fcst.organization_id = -1)

Line 1469: FROM msc_forecast_updates fcst, msc_system_items msi

1465: x_fcst_data_tab.sales_order_qty, x_fcst_data_tab.forecast_qty,
1466: x_fcst_data_tab.consumed_qty, x_fcst_data_tab.overconsumption_qty,
1467: x_fcst_data_tab.bom_item_type, x_fcst_data_tab.fixed_lt,
1468: x_fcst_data_tab.variable_lt, x_fcst_data_tab.cons_config_mod_flag
1469: FROM msc_forecast_updates fcst, msc_system_items msi
1470: WHERE fcst.sr_instance_id = atp_peg_tab.sr_instance_id(k)
1471: AND fcst.plan_id = atp_peg_tab.plan_id(k)
1472: AND (fcst.organization_id = atp_peg_tab.organization_id(k)
1473: OR fcst.organization_id = -1)

Line 1520: -- No data in msc_forecast_updates.

1516: -- Changes here in relation to Bug 3362558 not needed anymore.
1517: -- End Bug 3362558
1518:
1519: -- Bug 3362499
1520: -- No data in msc_forecast_updates.
1521: -- Bug 3417410 Determine if model line is present in data
1522: IF x_fcst_data_tab.inventory_item_id.COUNT = 0 THEN
1523: l_fcst_mod_flag := 0;
1524: ELSE

Line 3777: -- Not provided by MBP in msc_forecast_updates currently.

3773:
3774: -- Bug 3805136
3775: -- Set to 1 currently as a default.
3776: -- Usage Quantity to estimate end_item_usage
3777: -- Not provided by MBP in msc_forecast_updates currently.
3778: atp_peg_det.end_item_usage(k) := 1;
3779: -- Bug 3805136
3780:
3781: atp_peg_det.exclude_flag(k) := atp_peg_det.exclude_flag(i);