APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_PLANNERS

Line 835: -- msc_planners mp,

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,
839: msc_system_items msi,

Line 955: -- msc_planners mp,

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,
959: msc_system_items msi,

Line 1815: FROM msc_planners mp

1811:
1812: BEGIN
1813: SELECT mp.user_name
1814: INTO l_supplier_contact
1815: FROM msc_planners mp
1816: , msc_system_items msi
1817: WHERE msi.plan_id = -1 -- p_plan_id
1818: AND msi.organization_id = p_customer_model_org_id
1819: AND msi.inventory_item_id = p_inventory_item_id

Line 2501: l_supplier_contact msc_planners.user_name%TYPE;

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
2505: , p_customer_id NUMBER

Line 2523: FROM msc_planners mp

2519: , p_planner_code VARCHAR2
2520: , p_modeled_customer_org_id NUMBER
2521: ) IS
2522: SELECT mp.user_name
2523: FROM msc_planners mp
2524: WHERE mp.planner_code = p_planner_code
2525: AND mp.organization_id = p_modeled_customer_org_id
2526: AND mp.sr_instance_id = p_sr_instance_id
2527: ORDER BY mp.user_name