7867: FROM
7868: msc_trading_partners tp,
7869: msc_resource_requirements resreq,
7870: msc_supplies s,
7871: msc_resource_charges chg
7872: WHERE
7873: tp.sr_tp_id=s.organization_id
7874: AND tp.sr_instance_id= s.sr_instance_id
7875: AND tp.partner_type=3
9286: FROM
9287: msc_trading_partners tp,
9288: msc_resource_requirements resreq,
9289: msc_supplies s,
9290: msc_resource_charges chg
9291: WHERE
9292: tp.sr_tp_id=s.organization_id
9293: AND tp.sr_instance_id= s.sr_instance_id
9294: AND tp.partner_type=3
11994: FROM
11995: msc_trading_partners tp,
11996: msc_resource_requirements resreq,
11997: msc_supplies s,
11998: msc_resource_charges chg
11999: WHERE
12000: tp.sr_tp_id=s.organization_id
12001: AND tp.sr_instance_id= s.sr_instance_id
12002: AND tp.partner_type=3
13325: FROM
13326: msc_trading_partners tp,
13327: msc_resource_requirements resreq,
13328: msc_supplies s,
13329: msc_resource_charges chg
13330: WHERE
13331: tp.sr_tp_id=s.organization_id
13332: AND tp.sr_instance_id= s.sr_instance_id
13333: AND tp.partner_type=3