DBA Data[Home] [Help]

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 1415: msc_system_items msi

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

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

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

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

Line 1573: -- Just get the data from msc_system_items

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

Line 1576: FROM msc_system_items msi

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

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

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

Line 2139: msc_system_items msi

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

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

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

Line 2456: msc_system_items msi

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

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

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

Line 2604: msc_system_items msi,

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

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

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

Line 2859: FROM msc_system_items msi, msc_demands d

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

Line 3030: FROM msc_system_items msi, msc_demands d

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

Line 6619: msc_system_items msi, msc_item_hierarchy_mv alloc

6615: decode(alloc.inventory_item_id, null, 2 , 1)
6616: )
6617: ) offset_type
6618: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6619: msc_system_items msi, msc_item_hierarchy_mv alloc
6620: WHERE mapt.reference_item_id = p_reference_item_id
6621: AND mapt.plan_id = p_plan_id
6622: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6623: --AND mapt.demand_source_type = p_demand_source_type

Line 6671: msc_system_items msi

6667: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6668: mapt.inventory_item_id, mapt.transaction_date,
6669: alocd.customer_id, alocd.ship_to_site_id, 2
6670: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6671: msc_system_items msi
6672: WHERE mapt.reference_item_id = p_reference_item_id
6673: AND mapt.plan_id = p_plan_id
6674: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6675: --AND mapt.demand_source_type = p_demand_source_type

Line 7066: msc_system_items lid

7062: )
7063: ) offset_type
7064: FROM mrp_atp_details_temp peg,
7065: msc_item_hierarchy_mv alloc,
7066: msc_system_items lid
7067: WHERE peg.pegging_id = :p_identifier
7068: AND peg.identifier1 = :p_instance_id
7069: and peg.session_id = :l_session_id
7070: AND peg.record_type = 3

Line 7393: msc_system_items lid

7389: )
7390: ) offset_type
7391: FROM mrp_atp_details_temp peg,
7392: msc_item_hierarchy_mv alloc,
7393: msc_system_items lid
7394: WHERE peg.pegging_id <> :p_identifier
7395: AND peg.record_type in (3, 4)
7396: and peg.session_id = :l_session_id
7397: and lid.sr_inventory_item_id = peg.inventory_item_id