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.JG_ZZ_AERL_DT_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 70: from ar_cash_receipt_history_all crh, ce_statement_reconcils_all sr,ce_statement_lines sl

66: where invoice_id = pn_trx_id;
67: elsif pv_source = 'AR' then
68: if pv_entity_code = 'RECEIPTS' then
69: select sl.trx_type into lv_sl_trx_type
70: from ar_cash_receipt_history_all crh, ce_statement_reconcils_all sr,ce_statement_lines sl
71: where crh.cash_receipt_id = pn_trx_id
72: and crh.cash_receipt_history_id = sr.reference_id
73: and sr.statement_line_id = sl.statement_line_id;
74: select cr.reversal_category into lv_cr_reversal_category