APPS.WSH_TRANSACTIONS_FORM_PKG SQL Statements

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

Line: 92

SELECT document_type,document_number,orig_document_number,document_direction,transaction_status,
       action_type,entity_number,entity_type,trading_partner_id,ecx_message_id,
       event_name,event_key,internal_control_number,item_type
FROM   WSH_TRANSACTIONS_HISTORY
WHERE  transaction_id = P_transaction_id;

Line: 99

  IS select TRANSACTION_STATUS
  FROM wsh_transactions_history
  WHERE transaction_id = v_trx_id;