APPS.MSC_EXP_WF dependencies on MSC_PARTNER_CONTACTS

Line 2462: FROM msc_partner_contacts cont, msc_system_items sys

2458: p_plan_id in number,
2459: p_org_id in number,
2460: p_instance in number) IS
2461: SELECT cont.name
2462: FROM msc_partner_contacts cont, msc_system_items sys
2463: WHERE sys.inventory_item_id = p_inventory_item_id
2464: AND sys.organization_id = p_org_id
2465: AND sys.sr_instance_id = p_instance
2466: AND sys.plan_id = p_plan_id

Line 2473: FROM msc_partner_contacts cont,

2469: AND cont.partner_type = 4;
2470:
2471: CURSOR SUPCNT_C(p_exception_id in number,p_plan_id in number) IS
2472: SELECT name
2473: FROM msc_partner_contacts cont,
2474: msc_exception_details exp,
2475: msc_supplies ms
2476: WHERE exp.exception_detail_id = p_exception_id
2477: AND exp.plan_id = p_plan_id

Line 2509: FROM msc_partner_contacts cont, msc_demands mgr,

2505: AND mgr.demand_id = p_demand_id;
2506:
2507: CURSOR CUSTCNT_C(p_exception_id in number, p_plan_id in number) IS
2508: SELECT name
2509: FROM msc_partner_contacts cont, msc_demands mgr,
2510: msc_exception_details exp
2511: WHERE exp.exception_detail_id = p_exception_id
2512: AND exp.plan_id = p_plan_id
2513: AND cont.partner_id = mgr.customer_id

Line 2522: FROM msc_partner_contacts cont, msc_demands mgr

2518: AND mgr.plan_id = exp.plan_id;
2519:
2520: CURSOR CUSTCNT_C2(p_demand_id in number, p_plan_id in number) IS
2521: SELECT name
2522: FROM msc_partner_contacts cont, msc_demands mgr
2523: where cont.partner_id = mgr.customer_id
2524: AND cont.partner_site_id = mgr.customer_site_id
2525: AND cont.partner_type = 2
2526: and cont.sr_instance_id = mgr.sr_instance_id