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_RS_SKILLS_REPORT_PUB dependencies on JTF_RS_RESOURCE_SKILLS

Line 136: from fnd_lookups fnl, jtf_rs_resource_skills rsk,

132:
133: cursor c_res_skills is
134: select fnl.meaning skill_type, rsl.level_name, rsk.category_id, rsk.component_id,
135: rsk.subcategory, rsk.problem_code, rsk.product_id, rsk.platform_id
136: from fnd_lookups fnl, jtf_rs_resource_skills rsk,
137: jtf_rs_skill_levels_vl rsl
138: where lookup_type = 'JTF_RS_SKILL_CAT_TYPE'
139: and rsk.subcategory = lookup_code
140: and rsk.skill_level_id = rsl.skill_level_id

Line 175: l_subcategory jtf_rs_resource_skills.subcategory%type;

171: select component_name
172: from jtf_rs_components_v
173: where component_id = l_component_id;
174:
175: l_subcategory jtf_rs_resource_skills.subcategory%type;
176: l_problem_code jtf_rs_resource_skills.problem_code%type;
177: l_platform_id jtf_rs_resource_skills.platform_id%type;
178: l_product_id jtf_rs_resource_skills.product_id%type;
179:

Line 176: l_problem_code jtf_rs_resource_skills.problem_code%type;

172: from jtf_rs_components_v
173: where component_id = l_component_id;
174:
175: l_subcategory jtf_rs_resource_skills.subcategory%type;
176: l_problem_code jtf_rs_resource_skills.problem_code%type;
177: l_platform_id jtf_rs_resource_skills.platform_id%type;
178: l_product_id jtf_rs_resource_skills.product_id%type;
179:
180: l_component_id jtf_rs_resource_skills.component_id%type := null;

Line 177: l_platform_id jtf_rs_resource_skills.platform_id%type;

173: where component_id = l_component_id;
174:
175: l_subcategory jtf_rs_resource_skills.subcategory%type;
176: l_problem_code jtf_rs_resource_skills.problem_code%type;
177: l_platform_id jtf_rs_resource_skills.platform_id%type;
178: l_product_id jtf_rs_resource_skills.product_id%type;
179:
180: l_component_id jtf_rs_resource_skills.component_id%type := null;
181: l_category_id jtf_rs_resource_skills.category_id%type := null;

Line 178: l_product_id jtf_rs_resource_skills.product_id%type;

174:
175: l_subcategory jtf_rs_resource_skills.subcategory%type;
176: l_problem_code jtf_rs_resource_skills.problem_code%type;
177: l_platform_id jtf_rs_resource_skills.platform_id%type;
178: l_product_id jtf_rs_resource_skills.product_id%type;
179:
180: l_component_id jtf_rs_resource_skills.component_id%type := null;
181: l_category_id jtf_rs_resource_skills.category_id%type := null;
182: l_category_name jtf_rs_item_categories_v.category_name%type := null;

Line 180: l_component_id jtf_rs_resource_skills.component_id%type := null;

176: l_problem_code jtf_rs_resource_skills.problem_code%type;
177: l_platform_id jtf_rs_resource_skills.platform_id%type;
178: l_product_id jtf_rs_resource_skills.product_id%type;
179:
180: l_component_id jtf_rs_resource_skills.component_id%type := null;
181: l_category_id jtf_rs_resource_skills.category_id%type := null;
182: l_category_name jtf_rs_item_categories_v.category_name%type := null;
183: l_component_name jtf_rs_components_v.component_name%type := null;
184:

Line 181: l_category_id jtf_rs_resource_skills.category_id%type := null;

177: l_platform_id jtf_rs_resource_skills.platform_id%type;
178: l_product_id jtf_rs_resource_skills.product_id%type;
179:
180: l_component_id jtf_rs_resource_skills.component_id%type := null;
181: l_category_id jtf_rs_resource_skills.category_id%type := null;
182: l_category_name jtf_rs_item_categories_v.category_name%type := null;
183: l_component_name jtf_rs_components_v.component_name%type := null;
184:
185: l_skill_type fnd_lookups.meaning%type := null;