APPS.MSC_X_REPLENISH dependencies on MSC_PARTNER_CONTACTS
Line 481: FROM MSC_PARTNER_CONTACTS mpc
477: , p_partner_site_id NUMBER
478: , p_sr_instance_id NUMBER
479: ) IS
480: SELECT mpc.name 481: FROM MSC_PARTNER_CONTACTS mpc 482: WHERE mpc.partner_id = p_partner_id
483: AND mpc.partner_site_id = p_partner_site_id
484: AND mpc.sr_instance_id = p_sr_instance_id
485: AND mpc.partner_type = 1 -- supplier