DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on RCV_TRANSACTIONS

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

337: /* 1942696*/
338:
339: /** Bug#6497729:
340: ** When NO_DATA_FOUND exception occurs, we are setting 'deliver to person'/'deliver to location'
341: ** to Zero and this Zero is getting stored in rcv_transactions table for deliver_to_person_id
342: ** and deliver_to_location_id and causes data corruption.
343: ** So, we have set 'null' instead of setting it to Zero and we have to fire queries,
344: ** only if 'deliver to person'/'deliver to location' is not null.
345: */

Line 959: FROM rcv_transactions

955: /* Bug# 1717095 - Need to get the Currency details for the Order */
956:
957: SELECT currency_conversion_rate,currency_conversion_date
958: INTO x_currency_conv_rate,x_currency_conv_date
959: FROM rcv_transactions
960: WHERE transaction_id = x_transaction_id;
961:
962: END IF;
963: /*

Line 1343: FROM rcv_transactions

1339: /* Bug# 1717095 - Need to get the Currency details for the Order */
1340:
1341: SELECT currency_conversion_rate,currency_conversion_date
1342: INTO x_currency_conv_rate,x_currency_conv_date
1343: FROM rcv_transactions
1344: WHERE transaction_id = x_transaction_id;
1345:
1346: END IF;
1347: /*