How can we find the receipts related to a transmission?

Posted by Jiltin     24 February, 2009    3,508 views   

Every lockbox loading has a transmission name in oracle applications.
How can we find the receipts stuck or related to a transmission if they stored in interface?
Note: If you have setup to purge/delete the interface records after successful receipts, you may not get the receipts with this query.

SELECT transmission_id FROM                      
Ar_transmissions_all                    
WHERE transmission_name =‘wirep.05041908361_1′; – transmissionName is wirep.05041908361_1

SELECT * FROM AR_PAYMENTS_INTERFACE            
WHERE  transmission_id IN (                      
SELECT transmission_id FROM                      
Ar_transmissions_all                    
WHERE transmission_name =‘wirep.05041908361_1′); – transmissionName is wirep.05041908361_1

Following Google Searches Lead To This Post: AR_TRANSMISSIONS_ALL

Post to Twitter  Post to Delicious  Post to Digg    Post to StumbleUpon

Categories : 11i Scripts, Receivables Tags :

Comments

No comments yet.


Leave a comment

(required)

(required)