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 963: -- msc_planners mp,

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

Line 1827: FROM msc_planners mp

1823:
1824: BEGIN
1825: SELECT mp.user_name
1826: INTO l_supplier_contact
1827: FROM msc_planners mp
1828: , msc_system_items msi
1829: WHERE msi.plan_id = -1 -- p_plan_id
1830: AND msi.organization_id = p_customer_model_org_id
1831: AND msi.inventory_item_id = p_inventory_item_id

Line 2513: l_supplier_contact msc_planners.user_name%TYPE;

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

Line 2535: FROM msc_planners mp

2531: , p_planner_code VARCHAR2
2532: , p_modeled_customer_org_id NUMBER
2533: ) IS
2534: SELECT mp.user_name
2535: FROM msc_planners mp
2536: WHERE mp.planner_code = p_planner_code
2537: AND mp.organization_id = p_modeled_customer_org_id
2538: AND mp.sr_instance_id = p_sr_instance_id
2539: ORDER BY mp.user_name