DBA Data[Home] [Help]

APPS.MRP_EXP_WF dependencies on MTL_PLANNERS

Line 701: FROM mtl_planners mp,

697: CURSOR PLANNER_C(p_compile_designator in varchar2,
698: p_organization_id in number,
699: p_inventory_item_id in number) IS
700: SELECT mp.employee_id
701: FROM mtl_planners mp,
702: mrp_system_items items
703: WHERE mp.organization_id = items.organization_id
704: AND mp.planner_code = items.planner_code
705: AND items.inventory_item_id = p_inventory_item_id

Line 1787: FROM mtl_planners mplm,

1783: implement_task_id = task_id,
1784: implement_demand_class = NULL,
1785: implement_employee_id = ( SELECT
1786: decode(msi.planner_code,NULL,mplm.employee_id,mpl.employee_id)
1787: FROM mtl_planners mplm,
1788: mtl_planners mpl,
1789: mtl_parameters mparam,
1790: mtl_system_items master_msi,
1791: mtl_system_items msi

Line 1788: mtl_planners mpl,

1784: implement_demand_class = NULL,
1785: implement_employee_id = ( SELECT
1786: decode(msi.planner_code,NULL,mplm.employee_id,mpl.employee_id)
1787: FROM mtl_planners mplm,
1788: mtl_planners mpl,
1789: mtl_parameters mparam,
1790: mtl_system_items master_msi,
1791: mtl_system_items msi
1792: WHERE msi.organization_id = supplies.organization_id