7878: FROM msc_supplies p,
7879: -- msc_trading_partners tp,
7880: -- msc_calendar_dates c,
7881: -- msc_calendar_dates c1,
7882: msc_trading_partner_sites tps,
7883: msc_system_items I
7884: WHERE I.plan_id = p_plan_id
7885: AND I.atp_components_flag in ( 'Y', 'C')
7886: AND (p.order_type IN (5, 2)
7963: FROM msc_supplies p,
7964: -- msc_trading_partners tp,
7965: -- msc_calendar_dates c,
7966: -- msc_calendar_dates c1,
7967: msc_trading_partner_sites tps,
7968: msc_system_items I
7969: WHERE I.plan_id = p_plan_id
7970: AND I.atp_components_flag in ( 'Y', 'C')
7971: AND (p.order_type IN (5, 2)