DBA Data[Home] [Help]

APPS.ICX_PO_RCV_QTY SQL Statements

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

Line: 20

     SELECT nvl(sum(rt.primary_quantity), 0)
     INTO   x_correct_qty
     FROM   rcv_transactions rt
     WHERE  rt.parent_transaction_id = x_parent_trx_id
     AND    rt.transaction_type =  'CORRECT';