DBA Data[Home] [Help]

APPS.MSC_X_REPLENISH dependencies on MSC_PLANNERS

Line 494: FROM msc_planners mp

490: (
491: p_site_id IN NUMBER
492: ) IS
493: SELECT DISTINCT mp.user_name
494: FROM msc_planners mp
495: , msc_system_items msi
496: WHERE msi.plan_id = p_plan_id
497: AND msi.organization_id = p_site_id
498: AND msi.inventory_item_id = p_inventory_item_id

Line 2299: msc_planners mp

2295: begin
2296: select mp.employee_id
2297: into l_employee_id
2298: from msc_system_items si,
2299: msc_planners mp
2300: where si.organization_id = l_organization_id
2301: and si.inventory_item_id = l_inventory_item_id
2302: and si.plan_id = l_plan_id
2303: and si.sr_instance_id = l_sr_instance_id

Line 3285: msc_planners mp

3281:
3282: select mp.employee_id
3283: into l_employee_id
3284: from msc_system_items si,
3285: msc_planners mp
3286: WHERE si.organization_id = l_aps_customer_site_id
3287: AND si.inventory_item_id = p_item_id
3288: AND si.plan_id = VMI_PLAN_ID
3289: AND si.sr_instance_id = l_sr_instance_id