APPS.WSH_SC_DETAILS_REQUIRED_PKG SQL Statements

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

Line: 69

SQL_Stmt :=           'SELECT ''Y'' ';

Line: 91

SQL_Stmt := SQL_Stmt||'  (SELECT ''Default Sub Exists'' ';

Line: 141

SQL_Stmt :=           'SELECT ''Y'' ';

Line: 185

SQL_Stmt := SQL_Stmt||'  (SELECT ''default loc for this sub exists''';

Line: 240

SQL_Stmt :=           'SELECT ''Y''';

Line: 242

SQL_Stmt := SQL_Stmt||'  FROM (select  pl.picking_line_id, pld.warehouse_id, pld.shipped_quantity, ';

Line: 252

SQL_Stmt := SQL_Stmt||'  FROM (select pl.picking_line_id, pld.warehouse_id, pld.shipped_quantity, ';

Line: 298

SQL_Stmt := SQL_Stmt||'                              or (not exists (select null from mtl_serial_numbers_temp';

Line: 307

SQL_Stmt := SQL_Stmt||'                    (select nvl(sum(to_number(nvl(substr(nvl(to_serial_number,fm_serial_number),';