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.WIP_TIME_ENTRY_PUB dependencies on WIP_PREFERENCE_VALUES

Line 66: from wip_preference_values

62:
63: begin
64: select distinct case when (attribute_value_code/10) < 2 then 1 else 0 end
65: into l_temp
66: from wip_preference_values
67: where preference_id=26 and
68: level_id in (select level_id
69: from wip_preference_levels
70: where organization_id = p_organization_id and

Line 110: from wip_preference_values

106:
107: begin
108: select distinct decode(mod(attribute_value_code,10),1,1,0)
109: into l_temp
110: from wip_preference_values
111: where preference_id=26 and
112: level_id in (select level_id
113: from wip_preference_levels
114: where organization_id = p_organization_id and

Line 330: from wip_preference_values

326: from wip_preference_levels
327: where organization_id = p_organization_id
328: and department_id is null
329: and level_id in (select level_id
330: from wip_preference_values
331: where preference_id = 26)
332: and rownum=1;
333:
334: exception

Line 346: from wip_preference_values

342:
343: begin
344: select to_number(attribute_value_code)
345: into l_pref_value
346: from wip_preference_values
347: where level_id = l_level_id
348: and preference_id = 26;
349: exception
350: when no_data_found then

Line 357: from wip_preference_values

353: -- if records are inherited, then we will consider site as the upper level and not responsibility.
354:
355: select to_number(attribute_value_code)
356: into l_pref_value
357: from wip_preference_values
358: where level_id = 1
359: and preference_id = 26;
360:
361: when others then