DBA Data[Home] [Help]

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on MRP_SUGG_REP_SCHEDULES

Line 784: INDEX(msrs MRP_SUGG_REP_SCHEDULES_N3) */

780: -- Repetitive schedule line requirements
781: -- ===================================
782: SELECT /*+ORDERED
783: INDEX(list MRP_FORM_QUERY_N1)
784: INDEX(msrs MRP_SUGG_REP_SCHEDULES_N3) */
785: msrs.organization_id,
786: msrs.inventory_item_id,
787: -1,
788: -1,

Line 795: mrp_sugg_rep_schedules msrs

791: trunc(msrs.first_unit_start_date),
792: trunc(least(msrs.last_unit_start_date,g_cutoff_date-1)),
793: msrs.load_factor_rate
794: FROM mrp_form_query list,
795: mrp_sugg_rep_schedules msrs
796: WHERE msrs.first_unit_start_date < g_cutoff_date
797: AND msrs.compile_designator = g_designator
798: AND msrs.organization_id = list.number1
799: AND msrs.repetitive_line = list.number2