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.JTF_IH_TOOLS dependencies on AMS_SOURCE_CODES

Line 123: FROM AMS_SOURCE_CODES

119: IF l_source_code_id IS NOT NULL THEN
120: BEGIN
121: SELECT source_code, ARC_SOURCE_CODE_FOR, SOURCE_CODE_FOR_ID
122: INTO l_source_code, l_object_type, l_object_id
123: FROM AMS_SOURCE_CODES
124: WHERE source_code_id = l_source_code_id
125: and active_flag = l_active_flag;
126:
127: EXCEPTION

Line 136: FROM AMS_SOURCE_CODES

132: BEGIN
133: IF l_source_code IS NOT NULL THEN
134: SELECT source_code_id, ARC_SOURCE_CODE_FOR, SOURCE_CODE_FOR_ID
135: INTO l_source_code_id, l_object_type, l_object_id
136: FROM AMS_SOURCE_CODES
137: WHERE source_code = l_source_code
138: AND active_flag = l_active_flag;
139:
140: END IF;

Line 444: FROM AMS_SOURCE_CODES

440: -- and object_type values
441: begin
442: SELECT count(*), source_code_id, SOURCE_CODE_FOR_ID, ARC_SOURCE_CODE_FOR
443: INTO nCampCount, nSourceCodeID, nObjectId, vObjectType
444: FROM AMS_SOURCE_CODES
445: WHERE source_code = curOut.source_code
446: AND active_flag = l_active_flag
447: group by source_code_id, SOURCE_CODE_FOR_ID, ARC_SOURCE_CODE_FOR;
448: