APPS.RCV_DATES_S dependencies on RCV_TRANSACTIONS

Line 42: ** transaction date from rcv_transactions using the parent_transaction_id.

38: ** purchasing period.
39: **
40: ** 6) If the transaction type is not 'RECEIVE' or 'UNORDERED' then it checks
41: ** if the parent transaction date is null. If it is then get the parent
42: ** transaction date from rcv_transactions using the parent_transaction_id.
43: ** Then check that the parent transaction date is less than or equal to the
44: ** transaction date.
45: **
46: ** 7) If the transaction type is 'RECEIVE' internally, then gets the shipped

Line 214: FROM rcv_transactions

210: */
211:
212: SELECT transaction_date
213: INTO x_parent_trx_date
214: FROM rcv_transactions
215: WHERE transaction_id = x_parent_trx_id;
216:
217: END IF;
218: