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_ATP_PEG dependencies on MSC_SYSTEM_ITEMS

Line 124: -- and msc_system_items.

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(),
128: inventory_item_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 1381: msc_system_items msi

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)
1385: AND(fcst.sales_order_id = atp_peg_tab.original_demand_id(k) OR fcst.sales_order_id = atp_peg_tab.end_demand_id(k))

Line 1411: msc_system_items msi

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)
1415: AND(fcst.sales_order_id = atp_peg_tab.original_demand_id(k) OR fcst.sales_order_id = atp_peg_tab.end_demand_id(k))

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 1543: msc_util.msc_log('Get Data from msc_system_items for base_item_id');

1539: -- End Bug 3417410 Determine if model line is present in data
1540:
1541: IF l_fcst_mod_flag = 0 THEN -- Bug 3417410 If no model line is present in forecast
1542: IF PG_DEBUG in ('Y', 'C') THEN
1543: msc_util.msc_log('Get Data from msc_system_items for base_item_id');
1544: msc_util.msc_log('Provide default values for other forecast fields ');
1545: END IF;
1546: -- Get data from msc_system_items for the base_item_id
1547: -- and provide default values for other forecast related fields.

Line 1546: -- Get data from msc_system_items for the base_item_id

1542: IF PG_DEBUG in ('Y', 'C') THEN
1543: msc_util.msc_log('Get Data from msc_system_items for base_item_id');
1544: msc_util.msc_log('Provide default values for other forecast fields ');
1545: END IF;
1546: -- Get data from msc_system_items for the base_item_id
1547: -- and provide default values for other forecast related fields.
1548: -- Note Local forecast is assumed as a default.
1549: SELECT msi.plan_id, msi.sr_instance_id,
1550: msi.inventory_item_id, atp_peg_tab.inventory_item_id(k),

Line 1571: -- Just get the data from msc_system_items

1567: l_fcst_data_tab.bom_item_type, l_fcst_data_tab.fixed_lt,
1568: l_fcst_data_tab.variable_lt,
1569: -- Bug 3701093 Model overconsumption does not happen
1570: l_fcst_data_tab.cons_config_mod_flag
1571: -- Just get the data from msc_system_items
1572: -- and default the rest of the values.
1573: -- End Bug 3417410 Collect into local record.
1574: FROM msc_system_items msi
1575: WHERE msi.plan_id = atp_peg_tab.plan_id(k)

Line 1574: FROM msc_system_items msi

1570: l_fcst_data_tab.cons_config_mod_flag
1571: -- Just get the data from msc_system_items
1572: -- and default the rest of the values.
1573: -- End Bug 3417410 Collect into local record.
1574: FROM msc_system_items msi
1575: WHERE msi.plan_id = atp_peg_tab.plan_id(k)
1576: AND msi.sr_instance_id = atp_peg_tab.sr_instance_id(k)
1577: AND msi.organization_id = atp_peg_tab.organization_id(k)
1578: AND (msi.wip_supply_type = 6 or msi.bom_item_type = 1)

Line 1639: -- No data in msc_system_items for the base model

1635: -- Bug 3701093
1636: x_fcst_data_tab.cons_config_mod_flag(l_fcst_cnt) := C_NO_FCST_CONSUMED;
1637: -- Bug 3701093 Model and Config forecast consumption does not happen
1638: ELSE
1639: -- No data in msc_system_items for the base model
1640: -- Print out a Warning message.
1641: IF PG_DEBUG in ('Y', 'C') THEN
1642: msc_util.msc_log ( 'No plan data for Base Model ' ||
1643: atp_peg_tab.base_item_id(k) );

Line 2137: msc_system_items msi

2133: msc_demands d1,
2134: msc_full_pegging peg1 ,
2135: msc_full_pegging peg2 ,
2136: msc_supplies SUP,
2137: msc_system_items msi
2138: WHERE d1.plan_id = p_plan_id
2139: AND d1.sr_instance_id = c_items_rec.sr_instance_id
2140: AND d1.inventory_item_id = c_items_rec.inventory_item_id
2141: AND d1.origination_type IN (6,30)

Line 2164: -- Join to msc_system_items to filter out items

2160: AND SUP.transaction_id = peg2.transaction_id
2161: AND SUP.plan_id = peg2.plan_id
2162: AND SUP.sr_instance_id = peg2.sr_instance_id
2163: AND SUP.organization_id = peg2.organization_id
2164: -- Join to msc_system_items to filter out items
2165: -- from the pegging.
2166: AND msi.plan_id = SUP.plan_id
2167: AND msi.sr_instance_id = SUP.sr_instance_id
2168: AND msi.inventory_item_id = SUP.inventory_item_id

Line 2454: msc_system_items msi

2450: FROM
2451: msc_atp_detail_peg_temp adpt,
2452: msc_full_pegging peg1 ,
2453: msc_demands d1,
2454: msc_system_items msi
2455: WHERE adpt.plan_id = p_plan_id
2456: AND adpt.reference_item_id = c_items_rec.inventory_item_id
2457: AND adpt.sales_order_line_id = c_items_rec.sales_order_line_id
2458: AND decode(adpt.demand_source_type,100,adpt.demand_source_type,-1)

Line 2493: -- Join to msc_system_items to get items data

2489: -- AND d1.inventory_item_id <> adpt.inventory_item_id
2490: -- Get all the items which peg to the supply using the disposition_id.
2491: AND d1.disposition_id = adpt.supply_id
2492: AND d1.using_requirement_quantity > 0
2493: -- Join to msc_system_items to get items data
2494: AND msi.plan_id = d1.plan_id
2495: AND msi.sr_instance_id = d1.sr_instance_id
2496: AND msi.inventory_item_id = d1.inventory_item_id
2497: AND msi.organization_id = d1.organization_id

Line 2602: msc_system_items msi,

2598: FROM
2599: msc_atp_detail_peg_temp adpt,
2600: msc_full_pegging peg1 ,
2601: msc_demands d1,
2602: msc_system_items msi,
2603: msc_process_effectivity proc,
2604: msc_bom_components mbc
2605: WHERE adpt.plan_id = p_plan_id
2606: AND adpt.reference_item_id = c_items_rec.inventory_item_id

Line 2643: -- Join to msc_system_items to get items data

2639: -- AND d1.inventory_item_id <> adpt.inventory_item_id
2640: -- Get all the items which peg to the supply using the disposition_id.
2641: AND d1.disposition_id = adpt.supply_id
2642: AND d1.using_requirement_quantity > 0
2643: -- Join to msc_system_items to get items data
2644: AND msi.plan_id = d1.plan_id
2645: AND msi.sr_instance_id = d1.sr_instance_id
2646: AND msi.inventory_item_id = d1.inventory_item_id
2647: AND msi.organization_id = d1.organization_id

Line 2857: FROM msc_system_items msi, msc_demands d

2853: msi.sr_instance_id, msi.base_item_id, d.sales_order_line_id,
2854: decode(d.demand_source_type, 100, -- cmro fix
2855: d.demand_source_type, -1) demand_source_type, -- cmro fix
2856: d.demand_class, d.demand_id -- Bug 3319810 Add the sales_order demand class
2857: FROM msc_system_items msi, msc_demands d
2858: WHERE msi.plan_id = p_plan_id
2859: AND msi.bom_item_type = 4
2860: AND msi.base_item_id is NOT NULL
2861: AND msi.replenish_to_order_flag = 'Y'

Line 3028: FROM msc_system_items msi, msc_demands d

3024: msc_util.msc_log('MSC_ATP_PLAN_PARTITION_MISSING : Partition ' || l_partition_name || ' NOT FOUND');
3025: -- Find out presence of config items.
3026: SELECT 1
3027: INTO l_count
3028: FROM msc_system_items msi, msc_demands d
3029: WHERE msi.plan_id = p_plan_id
3030: AND msi.bom_item_type = 4
3031: AND msi.base_item_id is NOT NULL
3032: AND msi.replenish_to_order_flag = 'Y'

Line 6598: msc_system_items msi

6594: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6595: mapt.inventory_item_id, mapt.transaction_date,
6596: alocd.customer_id, alocd.ship_to_site_id
6597: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6598: msc_system_items msi
6599: WHERE mapt.reference_item_id = p_reference_item_id
6600: AND mapt.plan_id = p_plan_id
6601: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6602: --AND mapt.demand_source_type = p_demand_source_type