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 1192: FROM FND_LOOKUP_VALUES

1188: -- :Sr_Creation_Channel
1189: -- :Customer_Type
1190: CURSOR Get_Cs_Lookup (v_lookup_code VARCHAR2, v_lookup_type VARCHAR2) IS
1191: SELECT meaning
1192: FROM FND_LOOKUP_VALUES
1193: WHERE lookup_code = v_lookup_code
1194: AND lookup_type = v_lookup_type
1195: AND LANGUAGE = userenv('LANG')
1196: AND View_APPLICATION_ID = 170

Line 1216: FROM FND_LOOKUP_VALUES cont_type_lkup

1212:
1213: -- :Contact_Type
1214: CURSOR Get_Contact_Type (v_incident_id NUMBER) IS
1215: SELECT cont_type_lkup.meaning
1216: FROM FND_LOOKUP_VALUES cont_type_lkup
1217: ,cs_hz_sr_contact_points sr_cont
1218: WHERE sr_cont.contact_type=cont_type_lkup.lookup_code
1219: AND cont_type_lkup.lookup_type='CS_SR_CONTACT_TYPE'
1220: AND sr_cont.incident_id = v_incident_id

Line 1316: FND_LOOKUP_VALUES ar

1312: nvl2(party_cont.phone_area_code, party_cont.phone_area_code || '-', null) ||
1313: party_cont.phone_number PHONE_NUMBER
1314: FROM hz_contact_points party_cont,
1315: cs_hz_sr_contact_points sr_cont,
1316: FND_LOOKUP_VALUES ar
1317: WHERE sr_cont.incident_id = v_incident_id
1318: AND sr_cont.contact_point_id = party_cont.contact_point_id
1319: AND sr_cont.contact_type <> 'EMPLOYEE'
1320: AND party_cont.contact_point_type = 'PHONE'

Line 1524: FROM fnd_lookup_values problem

1520: FROM jtf_rs_resource_extns_tl rs
1521: WHERE rs.resource_id = sr.incident_owner_id
1522: AND rs.language = userenv(''LANG'') )Sr_Owner
1523: ,(SELECT problem.meaning
1524: FROM fnd_lookup_values problem
1525: WHERE problem.lookup_code = sr.problem_code
1526: AND problem.lookup_type = ''REQUEST_PROBLEM_CODE''
1527: AND problem.LANGUAGE = userenv(''LANG'')
1528: AND problem.View_APPLICATION_ID = 170

Line 1531: FROM fnd_lookup_values resolution

1527: AND problem.LANGUAGE = userenv(''LANG'')
1528: AND problem.View_APPLICATION_ID = 170
1529: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID) ) Problem_code
1530: ,(SELECT resolution.meaning
1531: FROM fnd_lookup_values resolution
1532: WHERE resolution.lookup_code = sr.resolution_code
1533: AND resolution.lookup_type = ''REQUEST_RESOLUTION_CODE''
1534: AND resolution.LANGUAGE = userenv(''LANG'')
1535: AND resolution.View_APPLICATION_ID = 170