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_ANALYSIS_BUDGET dependencies on MSC_DEMANDS

Line 479: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,

475: nvl(msd.probability,1)) AS required_quantity,
476: sum(nvl(msd.service_level, 50)) AS target_service_level,
477: count(*) AS num_target_service_level,
478: RECORD_SERVICE_LEVEL AS record_type
479: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,
480: msc_item_categories mic, msc_trading_partners mtp
481: WHERE mp.plan_id = p_plan_id
482: AND mp.plan_id = mpo.plan_id
483: AND mpo.plan_id = msd.plan_id

Line 569: FROM msc_demands demands

565: msi.item_name AS item_name, msd.customer_id AS partner_id
566: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp,
567: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
568: demands.customer_id, demands.demand_id
569: FROM msc_demands demands
570: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd,
571: (SELECT kpi.inventory_item_id, kpi.sr_instance_id, kpi.organization_id, kpi.plan_id
572: FROM msc_bis_inv_detail kpi
573: WHERE NVL(kpi.period_type, CALENDAR_TYPE_BIS) = p_calendar_type