eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_INITIATOR_WF_PKG dependencies on FUN_TRX_BATCHES

Line 104: FROM fun_trx_batches ftb,

100: l_currency,
101: l_recipient_name,
102: l_trx_number,
103: l_initiator_name
104: FROM fun_trx_batches ftb,
105: fun_trx_headers fth,
106: hz_parties hzp,
107: hz_parties ini
108: WHERE ftb.batch_id = l_batch_id

Line 483: FROM FUN_TRX_BATCHES ftb,

479: ftb.batch_id,
480: fth.trx_id,
481: ftb.from_ledger_id,
482: ftb.batch_date
483: FROM FUN_TRX_BATCHES ftb,
484: FUN_TRX_HEADERS fth
485: WHERE fth.trx_id=p_trx_id
486: AND fth.batch_id=ftb.batch_id
487: AND fth.status='APPROVED';

Line 990: -- Also since the fun_trx_batches table is not used in the query removing a reference to the same

986: p_batch_id => l_batch_id,
987: p_trx_id => l_trx_id);
988:
989: -- Bug: 7319371 Changing the query to make the l_trx_amt number reginal independent
990: -- Also since the fun_trx_batches table is not used in the query removing a reference to the same
991:
992: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),0,h.reci_amount_dr,h.reci_amount_cr),'999999999.99'))
993: --into l_trx_amt
994: --from fun_trx_headers h, fun_trx_batches b

Line 994: --from fun_trx_headers h, fun_trx_batches b

990: -- Also since the fun_trx_batches table is not used in the query removing a reference to the same
991:
992: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),0,h.reci_amount_dr,h.reci_amount_cr),'999999999.99'))
993: --into l_trx_amt
994: --from fun_trx_headers h, fun_trx_batches b
995: --where h.trx_id = l_trx_id
996: --and b.batch_id = l_batch_id;
997:
998: SELECT LTRIM(TO_CHAR(DECODE(NVL(H.RECI_AMOUNT_CR,0),0,H.RECI_AMOUNT_DR,