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_SERVICEREQUEST_PUB dependencies on FND_LOOKUP_VALUES

Line 6395: FROM FND_LOOKUP_VALUES problem

6391: WHERE rs.resource_id = inc.incident_owner_id
6392: AND language = userenv('LANG') )SrOwner
6393: ,inc.problem_code ProblemcodeId
6394: ,(SELECT problem.meaning
6395: FROM FND_LOOKUP_VALUES problem
6396: WHERE problem.lookup_code = inc.problem_code
6397: AND problem.lookup_type = 'REQUEST_PROBLEM_CODE'
6398: AND problem.LANGUAGE = userenv('LANG')
6399: AND problem.View_APPLICATION_ID = 170

Line 6404: FROM FND_LOOKUP_VALUES resolution

6400: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID)
6401: ) Problemcode
6402: ,inc.resolution_code ResolutioncodeId
6403: ,(SELECT resolution.meaning
6404: FROM FND_LOOKUP_VALUES resolution
6405: WHERE resolution.lookup_code = inc.resolution_code
6406: AND resolution.lookup_type = 'REQUEST_RESOLUTION_CODE'
6407: AND resolution.LANGUAGE = userenv('LANG')
6408: AND resolution.View_APPLICATION_ID = 170

Line 6413: FROM FND_LOOKUP_VALUES channel

6409: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE, resolution.VIEW_APPLICATION_ID)
6410: ) Resolutioncode
6411: ,inc.publish_flag PublishFlag
6412: ,(SELECT channel.meaning
6413: FROM FND_LOOKUP_VALUES channel
6414: WHERE channel.lookup_code = inc.sr_creation_channel
6415: AND channel.lookup_type = 'CS_SR_CREATION_CHANNEL'
6416: AND channel.LANGUAGE = userenv('LANG')
6417: AND channel.View_APPLICATION_ID = 170

Line 6427: from FND_LOOKUP_VALUES cont_type_lkup

6423: from fnd_user usr
6424: where usr.user_id = inc.created_by)CreatedBy
6425: ,sr_cont.party_id ContactPartyId
6426: ,(select cont_type_lkup.meaning
6427: from FND_LOOKUP_VALUES cont_type_lkup
6428: where sr_cont.contact_type=cont_type_lkup.lookup_code
6429: and cont_type_lkup.lookup_type = 'CS_SR_CONTACT_TYPE'
6430: AND cont_type_lkup.LANGUAGE = userenv('LANG')
6431: AND cont_type_lkup.View_APPLICATION_ID = 170

Line 6511: FROM FND_LOOKUP_VALUES cust_type_lkup

6507: and covb.id = covt.id
6508: and covt.language = userenv('LANG')
6509: and svl.id = inc.contract_service_id) ContractCoverageDescription
6510: ,( SELECT cust_type_lkup.meaning
6511: FROM FND_LOOKUP_VALUES cust_type_lkup
6512: WHERE party.party_type = cust_type_lkup.lookup_code
6513: AND cust_type_lkup.lookup_type='CS_SR_CALLER_TYPE'
6514: and cust_type_lkup.LANGUAGE = userenv('LANG')
6515: and cust_type_lkup.View_APPLICATION_ID = 170