APPS.POA_EDW_RCV_TXNS_PKG SQL Statements

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

Line: 28

    select sum(nvl(source_doc_quantity, 0)) into l_sum
      from rcv_transactions
     where shipment_line_id = p_shipment_line_id
       and transaction_type = p_transaction_type;

Line: 36

    select sum(nvl(rcv1.source_doc_quantity, 0)) into l_sum
      from rcv_transactions rcv1
     where rcv1.parent_transaction_id in
               (select transaction_id
                  from rcv_transactions rcv2
                 where rcv2.shipment_line_id = p_shipment_line_id
  		   and rcv2.transaction_type = p_transaction_type)
       and rcv1.transaction_type = 'CORRECT';

Line: 68

    select sum(nvl(source_doc_quantity, 0)) into l_sum
      from rcv_transactions
     where parent_transaction_id = p_transaction_id
       and transaction_type = 'CORRECT';

Line: 99

	select transaction_id, nvl(source_doc_quantity, 0) s_qty,
	       transaction_type
	  from rcv_transactions
	  where parent_transaction_id = p_pid;

Line: 120

    	    select sum(nvl(source_doc_quantity, 0)) into l_qty_cor_sum
	    from rcv_transactions
	    where parent_transaction_id = l_txn_id
	      and transaction_type = 'CORRECT';

Line: 154

    select max(transaction_date) into l_date
      from rcv_transactions
     where shipment_line_id = p_shipment_line_id
       and transaction_type = 'DELIVER';