DBA Data[Home] [Help]

APPS.RCV_CALL_LCM_WS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 9: from rcv_transactions_interface rti

5: ,x_retcode OUT NOCOPY NUMBER) IS
6:
7: cursor c_rsh_rti is
8: select *
9: from rcv_transactions_interface rti
10: where transaction_status_code = 'PENDING'
11: and processing_status_code = 'LC_PENDING'
12: and (transaction_type in ('RECEIVE', 'MATCH') or -- Bug 9109629
13: (transaction_type ='SHIP' and auto_transact_code in ('RECEIVE','DELIVER'))

Line 30: from rcv_transactions_interface rti

26:
27:
28: cursor c_rhi_rti is
29: select *
30: from rcv_transactions_interface rti
31: where transaction_status_code = 'PENDING'
32: and processing_status_code = 'LC_PENDING'
33: and (transaction_type in ('RECEIVE', 'MATCH') or -- Bug 9109629
34: (transaction_type ='SHIP' and auto_transact_code in ('RECEIVE','DELIVER'))