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 1410: FROM msc_forecast_updates fcst,

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

Line 1467: FROM msc_forecast_updates fcst, msc_system_items msi

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

Line 1518: -- No data in msc_forecast_updates.

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

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

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