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 962: -- msc_partner_contacts mpc,

958: nvl(msi.preprocessing_lead_time, 0),
959: nvl(msi.postprocessing_lead_time, 0),
960: 2
961: FROM
962: -- msc_partner_contacts mpc,
963: -- msc_planners mp,
964: msc_companies customer,
965: msc_company_sites customer_site,
966: msc_companies oem,

Line 2512: l_customer_contact msc_partner_contacts.name%TYPE;

2508: l_wf_process VARCHAR2(50);
2509: l_status VARCHAR2(100);
2510: l_refresh_number NUMBER;
2511:
2512: l_customer_contact msc_partner_contacts.name%TYPE;
2513: l_supplier_contact msc_planners.user_name%TYPE;
2514:
2515: CURSOR c_customer_contacts (
2516: p_sr_instance_id NUMBER

Line 2521: FROM msc_partner_contacts mpc

2517: , p_customer_id NUMBER
2518: , p_customer_site_id NUMBER
2519: ) IS
2520: SELECT mpc.name
2521: FROM msc_partner_contacts mpc
2522: WHERE mpc.partner_type = 2 ---Customer
2523: AND mpc.sr_instance_id = p_sr_instance_id
2524: AND mpc.partner_site_id = p_customer_site_id
2525: AND mpc.partner_id = p_customer_id