DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on HZ_PARTIES

Line 1282: hz_parties party,

1278: l_branch_country_code, --g_nit_rec.nit_type,
1279: g_nit_rec.verifying_digit,
1280: g_gl_je_rec.identifier
1281: FROM jl_co_gl_nits nit,
1282: hz_parties party,
1283: ce_bank_branches_v br,
1284: ce_bank_accounts ce_accts,
1285: ce_bank_acct_uses_all acctuse,
1286: ar_cash_receipts_all arcash

Line 1327: hz_parties rac,

1323: g_nit_rec.nit_type,
1324: g_nit_rec.verifying_digit,
1325: l_customer_num
1326: FROM jl_co_gl_nits jlcgn,
1327: hz_parties rac,
1328: hz_cust_accounts custacct
1329: WHERE custacct.cust_account_id = ar_trx.party_id
1330: AND REPLACE(rac.jgzz_fiscal_code,'-') = jlcgn.nit(+)
1331: AND custacct.party_id=rac.party_id;