APPS.MSC_POST_PRO dependencies on MSC_SUPPLIER_CAPACITIES

Line 7838: msc_supplier_capacities s,

7834: trunc(S.to_date) to_date,
7835: mis.delivery_calendar_code,
7836: mis.supplier_lead_time_date
7837: FROM msc_system_items I,
7838: msc_supplier_capacities s,
7839: msc_item_suppliers mis -- Bug 3912422 - Move to the inner query
7840: WHERE I.plan_id = p_plan_id
7841: AND I.atp_components_flag in ('Y', 'C')
7842: AND s.inventory_item_id = I.inventory_item_id

Line 7982: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because

7978: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7979: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7980: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7981:
7982: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because
7983: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
7984: p_new_refresh_number IN NUMBER)
7985: IS
7986: SELECT I.sr_instance_id,