DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PWB dependencies on MSC_COMPANY_RELATIONSHIPS

Line 451: msc_company_relationships mcrs,

447: select count(*)
448: from fnd_user fu,
449: msc_company_users mcu,
450: msc_trading_partner_maps map,
451: msc_company_relationships mcrs,
452: msc_trading_partners mtp
453: where fu.user_id = mcu.user_id
454: and mcu.company_id = mcrs.object_id
455: and mcrs.subject_id = 1

Line 482: msc_company_relationships mcrs,

478: select mtp.sr_instance_id, mtp.partner_id
479: from fnd_user fu,
480: msc_company_users mcu,
481: msc_trading_partner_maps map,
482: msc_company_relationships mcrs,
483: msc_trading_partners mtp
484: where fu.user_id = mcu.user_id
485: and mcu.company_id = mcrs.object_id
486: and mcrs.subject_id = 1