APPS.INV_SHORTCHECKEXEC_PVT dependencies on MTL_PLANNERS

Line 591: FROM mtl_planners MP,

587: --
588: CURSOR L_ShortTemp_csr IS
589: -- WIP component planner
590: SELECT DISTINCT FU.user_name user_name
591: FROM mtl_planners MP,
592: mtl_system_items MSI,
593: fnd_user FU,
594: mtl_short_chk_temp MSCT
595: WHERE L_ShortParam_rec.wip_notif_comp_planner_flag = 1

Line 606: FROM mtl_planners MP,

602: AND FU.employee_id = MP.employee_id
603: -- WIP assembly planner (discrete jobs)
604: UNION
605: SELECT DISTINCT FU.user_name
606: FROM mtl_planners MP,
607: mtl_system_items MSI,
608: wip_entities WE,
609: fnd_user FU,
610: mtl_short_chk_temp MSCT

Line 623: FROM mtl_planners MP,

619: AND FU.employee_id = MP.employee_id
620: -- WIP assembly planner (repetitive schedules)
621: UNION
622: SELECT DISTINCT FU.user_name
623: FROM mtl_planners MP,
624: mtl_system_items MSI,
625: wip_repetitive_schedules WRS,
626: wip_repetitive_items WRI,
627: fnd_user FU,

Line 680: FROM mtl_planners MP,

676: AND WRS.created_by = FU.user_id
677: -- OE item planner
678: UNION
679: SELECT DISTINCT FU.user_name user_name
680: FROM mtl_planners MP,
681: mtl_system_items MSI,
682: fnd_user FU,
683: mtl_short_chk_temp MSCT
684: WHERE L_ShortParam_rec.oe_notif_item_planner_flag = 1