1081: nvl(wt.primary_quantity, rt.amount) applied_units, /* Bug 4180323*/
1082: 0 applied_value,
1083: wt.rcv_transaction_id -- Added for 4735668
1084: FROM wip_transactions wt,
1085: rcv_transactions rt
1086: WHERE wt.wip_entity_id = p_entity_id
1087: AND rt.transaction_id = wt.rcv_transaction_id
1088: AND wt.transaction_date BETWEEN TRUNC(p_start_date)
1089: AND (TRUNC(p_end_date) + 0.99999)
1393: /* Added for bug4735668 to get the primary quantity of deliver
1394: as acquistion cost would be in the UOM of receipt */
1395: SELECT rt.primary_quantity
1396: INTO l_del_qty
1397: FROM RCV_TRANSACTIONS RT
1398: WHERE rt.transaction_id = c_res_rec.rcv_transaction_id;
1399:
1400: /* FP Bug 7346249 fix: check for -ve quantities */
1401: IF Sign(c_res_rec.applied_units) = -1 THEN