DBA Data[Home] [Help]

APPS.ICX_PO_RCV_QTY dependencies on RCV_TRANSACTIONS

Line 22: FROM rcv_transactions rt

18: BEGIN
19:
20: SELECT nvl(sum(rt.primary_quantity), 0)
21: INTO x_correct_qty
22: FROM rcv_transactions rt
23: WHERE rt.parent_transaction_id = x_parent_trx_id
24: AND rt.transaction_type = 'CORRECT';
25:
26: x_net_qty := x_primary_qty - x_correct_qty;