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.CS_ERES_INT_PKG dependencies on FND_LOOKUP_VALUES

Line 1121: FROM FND_LOOKUP_VALUES

1117: -- :Sr_Creation_Channel
1118: -- :Customer_Type
1119: CURSOR Get_Cs_Lookup (v_lookup_code VARCHAR2, v_lookup_type VARCHAR2) IS
1120: SELECT meaning
1121: FROM FND_LOOKUP_VALUES
1122: WHERE lookup_code = v_lookup_code
1123: AND lookup_type = v_lookup_type
1124: AND LANGUAGE = userenv('LANG')
1125: AND View_APPLICATION_ID = 170

Line 1145: FROM FND_LOOKUP_VALUES cont_type_lkup

1141:
1142: -- :Contact_Type
1143: CURSOR Get_Contact_Type (v_incident_id NUMBER) IS
1144: SELECT cont_type_lkup.meaning
1145: FROM FND_LOOKUP_VALUES cont_type_lkup
1146: ,cs_hz_sr_contact_points sr_cont
1147: WHERE sr_cont.contact_type=cont_type_lkup.lookup_code
1148: AND cont_type_lkup.lookup_type='CS_SR_CONTACT_TYPE'
1149: AND sr_cont.incident_id = v_incident_id

Line 1245: FND_LOOKUP_VALUES ar

1241: nvl2(party_cont.phone_area_code, party_cont.phone_area_code || '-', null) ||
1242: party_cont.phone_number PHONE_NUMBER
1243: FROM hz_contact_points party_cont,
1244: cs_hz_sr_contact_points sr_cont,
1245: FND_LOOKUP_VALUES ar
1246: WHERE sr_cont.incident_id = v_incident_id
1247: AND sr_cont.contact_point_id = party_cont.contact_point_id
1248: AND sr_cont.contact_type <> 'EMPLOYEE'
1249: AND party_cont.contact_point_type = 'PHONE'

Line 1448: FROM fnd_lookup_values problem

1444: FROM jtf_rs_resource_extns_tl rs
1445: WHERE rs.resource_id = sr.incident_owner_id
1446: AND rs.language = userenv(''LANG'') )Sr_Owner
1447: ,(SELECT problem.meaning
1448: FROM fnd_lookup_values problem
1449: WHERE problem.lookup_code = sr.problem_code
1450: AND problem.lookup_type = ''REQUEST_PROBLEM_CODE''
1451: AND problem.LANGUAGE = userenv(''LANG'')
1452: AND problem.View_APPLICATION_ID = 170

Line 1455: FROM fnd_lookup_values resolution

1451: AND problem.LANGUAGE = userenv(''LANG'')
1452: AND problem.View_APPLICATION_ID = 170
1453: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID) ) Problem_code
1454: ,(SELECT resolution.meaning
1455: FROM fnd_lookup_values resolution
1456: WHERE resolution.lookup_code = sr.resolution_code
1457: AND resolution.lookup_type = ''REQUEST_RESOLUTION_CODE''
1458: AND resolution.LANGUAGE = userenv(''LANG'')
1459: AND resolution.View_APPLICATION_ID = 170