APPS.CHV_BUILD_SCHEDULES dependencies on MTL_PLANNERS

Line 178: FROM mtl_system_items msi,mtl_planners mtp

174: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
175: AND (p_planner_code IS NULL
176: OR
177: EXISTS (SELECT 'check if planner exists in mtl_system_items'
178: FROM mtl_system_items msi,mtl_planners mtp
179: WHERE msi.planner_code = p_planner_code
180: AND msi.organization_id = x_organization_id
181: AND mtp.organization_id = x_organization_id
182: AND mtp.planner_code = p_planner_code

Line 253: FROM mtl_system_items msi,mtl_planners mtp

249: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
250: AND (p_planner_code IS NULL
251: OR
252: EXISTS (SELECT 'check if planner exists in mtl_system_items'
253: FROM mtl_system_items msi,mtl_planners mtp
254: WHERE msi.planner_code = p_planner_code
255: AND msi.inventory_item_id = paa.item_id
256: AND mtp.organization_id = x_organization_id
257: AND mtp.planner_code = p_planner_code

Line 807: FROM mtl_planners mpl

803: x_str := null;
804: IF p_planner_code IS NOT NULL THEN
805: BEGIN
806: SELECT 'Y' INTO x_dummy
807: FROM mtl_planners mpl
808: WHERE mpl.planner_code = p_planner_code
809: AND mpl.organization_id = x_organization_id
810: AND nvl(mpl.disable_date,sysdate +1 ) > sysdate;
811: EXCEPTION

Line 1464: FROM mtl_system_items msi,mtl_planners mtp

1460: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
1461: AND (p_planner_code IS NULL
1462: OR
1463: EXISTS (SELECT 'check if planner exists in mtl_system_items'
1464: FROM mtl_system_items msi,mtl_planners mtp
1465: WHERE msi.planner_code = p_planner_code
1466: AND msi.inventory_item_id = paa.item_id
1467: AND mtp.organization_id = x_organization_id
1468: AND mtp.planner_code = p_planner_code