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.CLN_RN_UTILS dependencies on CE_BANK_BRANCHES_V

Line 427: FROM CE_BANK_BRANCHES_V bb, HZ_PARTIES hp, HZ_contact_points hcp

423: AND pvsa.vendor_site_id = l_party_site_id;
424: ELSIF (l_party_type = 'B') THEN
425: SELECT BANK_BRANCH_NAME,hcp.RAW_PHONE_NUMBER,hcp.EDI_ECE_TP_LOCATION_CODE
426: INTO x_name, x_telephone, x_ece_location_code
427: FROM CE_BANK_BRANCHES_V bb, HZ_PARTIES hp, HZ_contact_points hcp
428: WHERE bb.BRANCH_PARTY_ID = l_party_id
429: AND bb.BRANCH_PARTY_ID = hp.party_id
430: AND hp.PRIMARY_PHONE_CONTACT_PT_ID = hcp.CONTACT_POINT_ID;
431: ELSIF (l_party_type = 'I') THEN