7188: FROM
7189: msc_trading_partners tp,
7190: msc_resource_requirements resreq,
7191: msc_supplies s,
7192: msc_resource_charges chg
7193: WHERE
7194: tp.sr_tp_id=s.organization_id
7195: AND tp.sr_instance_id= s.sr_instance_id
7196: AND tp.partner_type=3
8443: FROM
8444: msc_trading_partners tp,
8445: msc_resource_requirements resreq,
8446: msc_supplies s,
8447: msc_resource_charges chg
8448: WHERE
8449: tp.sr_tp_id=s.organization_id
8450: AND tp.sr_instance_id= s.sr_instance_id
8451: AND tp.partner_type=3