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_POST_PRO dependencies on MSC_SUPPLIER_CAPACITIES

Line 7809: msc_supplier_capacities s,

7805: trunc(S.to_date) to_date,
7806: mis.delivery_calendar_code,
7807: mis.supplier_lead_time_date
7808: FROM msc_system_items I,
7809: msc_supplier_capacities s,
7810: msc_item_suppliers mis -- Bug 3912422 - Move to the inner query
7811: WHERE I.plan_id = p_plan_id
7812: AND I.atp_components_flag in ('Y', 'C')
7813: AND s.inventory_item_id = I.inventory_item_id

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

7949: l_ins_supplier_site_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7950: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
7951: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7952:
7953: CURSOR c_net_sup (p_plan_id IN NUMBER, -- Cursor does not require msc_supplier_capacities because
7954: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
7955: p_new_refresh_number IN NUMBER)
7956: IS
7957: SELECT I.sr_instance_id,