APPS.CSTPPWRO dependencies on RCV_TRANSACTIONS

Line 1086: rcv_transactions rt

1082: nvl(wt.primary_quantity, rt.amount) applied_units, /* Bug 4180323*/
1083: 0 applied_value,
1084: wt.rcv_transaction_id -- Added for 4735668
1085: FROM wip_transactions wt,
1086: rcv_transactions rt
1087: WHERE wt.wip_entity_id = p_entity_id
1088: AND rt.transaction_id = wt.rcv_transaction_id
1089: AND wt.transaction_date BETWEEN TRUNC(p_start_date)
1090: AND (TRUNC(p_end_date) + 0.99999)

Line 1398: FROM RCV_TRANSACTIONS RT

1394: /* Added for bug4735668 to get the primary quantity of deliver
1395: as acquistion cost would be in the UOM of receipt */
1396: SELECT rt.primary_quantity, rt.transaction_type
1397: INTO l_del_qty, l_rcv_txn_type
1398: FROM RCV_TRANSACTIONS RT
1399: WHERE rt.transaction_id = c_res_rec.rcv_transaction_id;
1400:
1401: IF(l_rcv_txn_type = 'RETURN TO VENDOR' OR l_rcv_txn_type = 'RETURN TO RECEIVING') THEN --bug 16056941, this if statement check should be only for RTV or RTR. for other types,the quantity in RT is the same as WT.
1402: /* FP Bug 7346249 fix: check for -ve quantities */