90: decode(br.basis_type,1,ls.planned_quantity -
91: nvl(ls.quantity_completed,0) , 2, 1))
92: FROM bom_calendar_dates cal_start,
93: bom_calendar_dates cal_order,
94: mtl_system_items items,
95: mtl_parameters mp,
96: mrp_form_query mfq,
97: bom_operation_resources br,
98: bom_operation_sequences bos,