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.JL_CO_GL_NIT_MANAGEMENT dependencies on HZ_PARTIES

Line 1788: hz_parties rac,

1784: g_nit_rec.nit_type,
1785: g_nit_rec.verifying_digit,
1786: l_customer_num
1787: FROM jl_co_gl_nits jlcgn,
1788: hz_parties rac,
1789: hz_cust_accounts custacct
1790: WHERE custacct.cust_account_id = TO_NUMBER(ar_trx.reference_7)
1791: AND REPLACE(rac.jgzz_fiscal_code,'-') = jlcgn.nit(+)
1792: AND custacct.party_id=rac.party_id;

Line 2053: hz_parties party,

2049: l_branch_country_code, --g_nit_rec.nit_type,
2050: g_nit_rec.verifying_digit,
2051: g_gl_je_rec.identifier
2052: FROM jl_co_gl_nits nit,
2053: hz_parties party,
2054: ce_bank_branches_v br,
2055: ce_bank_accounts ce_accts,
2056: ce_bank_acct_uses_all acctuse,
2057: -- Bug 14283808 Start

Line 2113: hz_parties rac,

2109: g_nit_rec.nit_type,
2110: g_nit_rec.verifying_digit,
2111: l_customer_num
2112: FROM jl_co_gl_nits jlcgn,
2113: hz_parties rac,
2114: hz_cust_accounts custacct
2115: WHERE custacct.cust_account_id = ar_trx.party_id
2116: AND substr(jgzz_fiscal_code,1,decode(instr(jgzz_fiscal_code,'-'),0,14,instr(jgzz_fiscal_code,'-')-1)) = jlcgn.nit(+) --bug8685975
2117: AND custacct.party_id=rac.party_id;