APPS.MRP_GET_BIS_VALUES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

  SELECT max(rec.new_schedule_date - peg2.demand_date)
  FROM mrp_recommendations rec,
        mrp_full_pegging peg1,
        mrp_full_pegging peg2
  WHERE peg1.demand_id = p_demand_id
    AND peg1.transaction_id = rec.transaction_id
    AND peg1.pegging_id = peg2.end_pegging_id
    AND peg2.organization_id = p_organization_id
    AND peg2.compile_designator = p_compile_designator
    AND peg1.organization_id = p_organization_id
    AND peg1.compile_designator = p_compile_designator;