APPS.CSP_PACKLIST_PVT SQL Statements

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

Line: 13

  select sum(nvl(cpal.quantity_packed,0))
  from   csp_packlist_lines cpal
  where  cpal.picklist_line_id = p_picklist_line_id;

Line: 33

  select sum(nvl(cpasl.quantity,0))
  from   csp_packlist_serial_lots cpasl,
         csp_packlist_lines cpal
  where  cpal.picklist_line_id = p_picklist_line_id
  and    cpasl.packlist_line_id = cpal.packlist_line_id
  and    decode(p_serial_number,null,'1',cpasl.serial_number) = decode(p_serial_number,null,'1',p_serial_number)
  and    decode(p_lot_number,null,'1',cpasl.lot_number) = decode(p_lot_number,null,'1',p_lot_number);