DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PWB dependencies on MSC_COMPANY_RELATIONSHIPS

Line 411: msc_company_relationships mcrs,

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

Line 442: msc_company_relationships mcrs,

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