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.IEX_UWQ_SEL_PKG dependencies on JTF_CONTACT_POINTS_V

Line 407: FROM JTF_CONTACT_POINTS_V

403: PROCEDURE GetDtlsFromPhoneNum IS
404:
405: CURSOR C_getDtlsFromPhoneNum(x_phonenumber varchar2 ) IS
406: SELECT party_id, party_type
407: FROM JTF_CONTACT_POINTS_V
408: WHERE phone_number = x_phonenumber ;
409:
410: CURSOR C_getDtlsFromAreaPhoneNum(x_AreaCode varchar2, x_phonenumber varchar2 ) IS
411: SELECT party_id, party_type

Line 412: FROM JTF_CONTACT_POINTS_V

408: WHERE phone_number = x_phonenumber ;
409:
410: CURSOR C_getDtlsFromAreaPhoneNum(x_AreaCode varchar2, x_phonenumber varchar2 ) IS
411: SELECT party_id, party_type
412: FROM JTF_CONTACT_POINTS_V
413: WHERE AREA_CODE = x_AreaCode and PHONE_NUMBER = x_phonenumber;
414: -- Changed for bug#7685201 by PNAVEENK on 5-1-2009
415: CURSOR C_GetSubObj(p_rel_partyid number) is
416: SELECT object_id, subject_id from