DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 4468: rcv_transactions_interface rti,mtl_material_transactions_temp mmtt

4464:
4465: IF (v_mmtt.transaction_type_id = 3) THEN
4466:
4467: SELECT Count(1) INTO l_rtv_exist FROM
4468: rcv_transactions_interface rti,mtl_material_transactions_temp mmtt
4469: WHERE rti.interface_transaction_id = mmtt.source_line_id
4470: AND rti.processing_status_code = 'WSH_INTERFACED'
4471: AND rti.group_id = mmtt.transaction_source_name
4472: AND mmtt.transaction_temp_id = v_mmtt.transaction_temp_id ;

Line 5349: SELECT interface_transaction_id FROM rcv_transactions_interface rti,wms_lpn_contents wlc

5345:
5346: -- End of bug 7226314,7355087
5347:
5348: CURSOR c_rtv_exists (p_lpn_id NUMBER ,p_organization_id NUMBER ) IS --RTV Change 16197273
5349: SELECT interface_transaction_id FROM rcv_transactions_interface rti,wms_lpn_contents wlc
5350: WHERE rti.interface_transaction_id = wlc.source_header_id
5351: AND rti.processing_status_code = 'WSH_INTERFACED'
5352: AND rti.to_organization_id = wlc.organization_id
5353: AND wlc.parent_lpn_id = p_lpn_id