407: select count(*)
408: from fnd_user fu,
409: msc_company_users mcu,
410: msc_trading_partner_maps map,
411: msc_company_relationships mcrs,
412: msc_trading_partners mtp
413: where fu.user_id = mcu.user_id
414: and mcu.company_id = mcrs.object_id
415: and mcrs.subject_id = 1
438: select mtp.sr_instance_id, mtp.partner_id
439: from fnd_user fu,
440: msc_company_users mcu,
441: msc_trading_partner_maps map,
442: msc_company_relationships mcrs,
443: msc_trading_partners mtp
444: where fu.user_id = mcu.user_id
445: and mcu.company_id = mcrs.object_id
446: and mcrs.subject_id = 1