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_BR_AR_LOG_VALIDATION dependencies on HZ_ORGANIZATION_PROFILES

Line 181: hz_organization_profiles prof

177: nvl(occ.bank_party_id,0) --bug 8527766 - can be NULL in occ table
178: INTO X_jlbr_bank_number,
179: p_bank_party_id
180: FROM jl_br_ar_bank_occurrences occ,
181: hz_organization_profiles prof
182: WHERE prof.bank_or_branch_number = X_bank_number
183: AND occ.bank_party_id = prof.party_id
184: AND prof.home_country ='BR'
185: AND rownum = 1;

Line 208: hz_organization_profiles prof

204: -- CE uptake - Bug#2932986
205: SELECT occ.std_occurrence_code
206: INTO X_bank_occurrence_code_std
207: FROM jl_br_ar_bank_occurrences occ,
208: hz_organization_profiles prof
209: WHERE occ.bank_occurrence_code = X_bank_occurrence_code
210: AND prof.bank_or_branch_number = X_bank_number
211: AND occ.bank_party_id = prof.party_id
212: AND prof.home_country ='BR'