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_SAFETY_STOCK dependencies on MSC_PLAN_ORGANIZATIONS

Line 651: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo,

647: cust.partner_name AS partner_name,
648: cust.customer_class_code AS customer_class_code,
649: RECORD_SERVICE_LEVEL AS record_type
650: FROM msc_demands msd, msc_system_items msi,
651: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo,
652: msc_trading_partners cust
653: WHERE mp.plan_id = p_plan_id
654: AND msd.plan_id = msi.plan_id
655: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)

Line 752: msc_plans mp, msc_plan_organizations mpo

748: NULL AS partner_name,
749: NULL AS customer_class_code,
750: RECORD_SAFETY_STOCK AS record_type
751: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,
752: msc_plans mp, msc_plan_organizations mpo
753: WHERE mss.sr_instance_id = msi.sr_instance_id
754: AND mss.plan_id = msi.plan_id
755: AND mss.organization_id = msi.organization_id
756: AND mss.inventory_item_id = msi.inventory_item_id