APPS.POS_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';

Line: 36

	select sum(quantity) into l_quantity from rcv_transactions where
	shipment_line_id = x_shipment_line_id
	and transaction_type = 'RECEIVE';

Line: 58

        SELECT rt.quantity,rt.transaction_type,rt1.transaction_type
        FROM rcv_transactions rt, rcv_transactions rt1
        WHERE rt.shipment_line_id=x_shipment_line_id
        AND rt1.transaction_id=rt.parent_transaction_id
        AND rt.transaction_type in ('CORRECT','RETURN TO VENDOR');

Line: 106

     SELECT transaction_id,
            quantity,
            transaction_type,
            parent_transaction_id
     FROM   rcv_transactions
     START WITH transaction_id = c_transaction_id
     CONNECT BY parent_transaction_id = PRIOR transaction_id;

Line: 133

           SELECT transaction_type
           INTO   l_parent_type
           FROM   rcv_transactions
           WHERE  transaction_id = l_parent_id;