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

Line 1022: FROM ra_cust_trx_line_gl_dist_all gl_dist,

1018: 0 taxable_amt, -- -1*zx_dist.taxable_amt taxable_amt,
1019: 0 taxable_amt_funcl_curr, -- -1*zx_dist.taxable_amt_funcl_curr taxable_amt_funcl_curr,
1020: 0 tax_amt, -- -1*zx_dist.prd_tax_amt tax_amt,
1021: 0 tax_amt_funcl_curr -- -1*zx_dist.prd_tax_amt_funcl_curr tax_amt_funcl_curr
1022: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1023: xla_distribution_links lnk,
1024: xla_ae_headers aeh,
1025: xla_ae_lines ael,
1026: xla_acct_class_assgns acs,

Line 1032: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

1028: WHERE gl_dist.customer_trx_id = c_trx_id
1029: AND gl_dist.customer_trx_line_id = c_trx_line_id
1030: AND gl_dist.account_class = 'REV'
1031: AND lnk.application_id = 222
1032: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1033: AND lnk.source_distribution_id_num_1 = gl_dist.cust_trx_line_gl_dist_id
1034: AND lnk.ae_header_id = ael.ae_header_id
1035: AND lnk.ae_line_num = ael.ae_line_num
1036: AND aeh.ae_header_id = ael.ae_header_id