APPS.WSH_SHIPMENT_ADVICE_PKG SQL Statements

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

Line: 162

      select transaction_status
      from   wsh_transactions_history
      where  transaction_id = c_trx_id;

Line: 168

      SELECT wth.Transaction_ID,
             wth.Document_Type,
             wth.Document_Direction,
             wth.Document_Number,
             wth.Orig_Document_Number,
             wth.Entity_Number,
             wth.Entity_Type,
             wth.Trading_Partner_ID,
             wth.Action_Type,
             wth.Transaction_Status,
             wth.ECX_Message_ID,
             wth.Event_Name,
             wth.Event_Key,
             wth.Item_Type,
             wth.Internal_Control_Number,
	     wth.document_revision,
             wth.Attribute_Category,
             wth.Attribute1,
             wth.Attribute2,
             wth.Attribute3,
             wth.Attribute4,
             wth.Attribute5,
             wth.Attribute6,
             wth.Attribute7,
             wth.Attribute8,
             wth.Attribute9,
             wth.Attribute10,
             wth.Attribute11,
             wth.Attribute12,
             wth.Attribute13,
             wth.Attribute14,
             wth.Attribute15,
	     null
   FROM   Wsh_Transactions_History wth,
          Wsh_New_Del_Interface wndi
   WHERE  wndi.interface_action_code = g_interface_action_code
   AND    wndi.delivery_interface_id = to_number(wth.entity_number)
   AND    wth.transaction_id = p_transaction_id
   AND    wth.transaction_status = nvl(p_transaction_status, wth.transaction_status);

Line: 272

      l_transaction_query := 'SELECT wth.Transaction_ID, ';

Line: 594

      WSH_DEBUG_SV.log(l_module_name,'No. of Shipment Advices selected for processing  ', l_total);

Line: 602

      FND_FILE.put_line(FND_FILE.output, 'No. of Shipment Advices selected for processing   => ' || l_total);