DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on RCV_TRANSACTIONS

Line 364: ** to Zero and this Zero is getting stored in rcv_transactions table for deliver_to_person_id

360: /* 1942696*/
361:
362: /** Bug#6497729:
363: ** When NO_DATA_FOUND exception occurs, we are setting 'deliver to person'/'deliver to location'
364: ** to Zero and this Zero is getting stored in rcv_transactions table for deliver_to_person_id
365: ** and deliver_to_location_id and causes data corruption.
366: ** So, we have set 'null' instead of setting it to Zero and we have to fire queries,
367: ** only if 'deliver to person'/'deliver to location' is not null.
368: */

Line 986: FROM rcv_transactions

982: /* Bug# 1717095 - Need to get the Currency details for the Order */
983:
984: SELECT currency_conversion_rate,currency_conversion_date
985: INTO x_currency_conv_rate,x_currency_conv_date
986: FROM rcv_transactions
987: WHERE transaction_id = x_transaction_id;
988:
989: END IF;
990: /*

Line 1370: FROM rcv_transactions

1366: /* Bug# 1717095 - Need to get the Currency details for the Order */
1367:
1368: SELECT currency_conversion_rate,currency_conversion_date
1369: INTO x_currency_conv_rate,x_currency_conv_date
1370: FROM rcv_transactions
1371: WHERE transaction_id = x_transaction_id;
1372:
1373: END IF;
1374: /*