APPS.MRP_BIS_PLAN SQL Statements

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

Line: 11

   select nvl(sum(nvl(schedule_quantity, 0)),0)
   into quantity
   from mrp_schedule_dates
   where inventory_item_id = item_id
   and   organization_id = org_id
   and   schedule_designator = sched_desig
   and   schedule_date = sched_date;