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

Line 649: ,cp_party_id hz_parties.party_id%TYPE) IS

645: WHERE dnz_chr_id = cp_chr_id
646: AND jtot_object1_code = 'OKX_PARTY'; -- this indicates non primary parties
647:
648: CURSOR c_get_party_info_csr(cp_chr_id okc_k_headers_b.id%TYPE
649: ,cp_party_id hz_parties.party_id%TYPE) IS
650: SELECT cpl.id
651: ,cpl.chr_id
652: ,cpl.rle_code
653: ,cpl.dnz_chr_id

Line 1373: hz_parties hzp,

1369: hz_cust_accounts hzc,
1370: hz_cust_site_uses_all hzcsu,
1371: okc_rg_party_roles rgrp,
1372: okc_rule_groups_b rgpb,
1373: hz_parties hzp,
1374: okc_rules_b rulb
1375: WHERE cplv.dnz_chr_id = chrb.id
1376: and cplv.chr_id = chrb.id
1377: and hzc.cust_account_id(+) = cplv.cust_acct_id