APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_PARTNER_CONTACTS

Line 834: -- msc_partner_contacts mpc,

830: nvl(msi.preprocessing_lead_time, 0),
831: nvl(msi.postprocessing_lead_time, 0),
832: 1
833: FROM
834: -- msc_partner_contacts mpc,
835: -- msc_planners mp,
836: msc_companies customer,
837: msc_company_sites customer_site,
838: msc_companies oem,

Line 954: -- msc_partner_contacts mpc,

950: nvl(msi.preprocessing_lead_time, 0),
951: nvl(msi.postprocessing_lead_time, 0),
952: 2
953: FROM
954: -- msc_partner_contacts mpc,
955: -- msc_planners mp,
956: msc_companies customer,
957: msc_company_sites customer_site,
958: msc_companies oem,

Line 2500: l_customer_contact msc_partner_contacts.name%TYPE;

2496: l_wf_process VARCHAR2(50);
2497: l_status VARCHAR2(100);
2498: l_refresh_number NUMBER;
2499:
2500: l_customer_contact msc_partner_contacts.name%TYPE;
2501: l_supplier_contact msc_planners.user_name%TYPE;
2502:
2503: CURSOR c_customer_contacts (
2504: p_sr_instance_id NUMBER

Line 2509: FROM msc_partner_contacts mpc

2505: , p_customer_id NUMBER
2506: , p_customer_site_id NUMBER
2507: ) IS
2508: SELECT mpc.name
2509: FROM msc_partner_contacts mpc
2510: WHERE mpc.partner_type = 2 ---Customer
2511: AND mpc.sr_instance_id = p_sr_instance_id
2512: AND mpc.partner_site_id = p_customer_site_id
2513: AND mpc.partner_id = p_customer_id