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.JE_ZZ_AUTO_INVOICE dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 66: FROM ra_cust_trx_line_gl_dist_all trxd

62: BEGIN
63:
64: UPDATE zx_lines_det_factors zxld
65: SET zxld.tax_invoice_date = (SELECT MAX(trxd.gl_date)
66: FROM ra_cust_trx_line_gl_dist_all trxd
67: WHERE trxd.request_id= p_request_id
68: AND trxd.org_id= l_org_id
69: AND trxd.customer_trx_id=zxld.trx_id
70: AND trxd.set_of_books_id = zxld.ledger_id

Line 76: FROM ra_cust_trx_line_gl_dist_all trxd1

72: AND trxd.latest_rec_flag = 'Y'
73: AND zxld.application_id=222
74: AND zxld.tax_invoice_date IS NULL)
75: WHERE EXISTS (SELECT 1
76: FROM ra_cust_trx_line_gl_dist_all trxd1
77: WHERE trxd1.request_id= p_request_id
78: AND trxd1.org_id= l_org_id
79: AND trxd1.customer_trx_id=zxld.trx_id
80: AND trxd1.set_of_books_id = zxld.ledger_id