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_WS_UTIL dependencies on WIP_PREFERENCE_VALUES

Line 88: from wip_preference_values v1

84: ( v.department_id is null or v.department_id = p_dept_id) and
85: exists
86: (
87: select 1
88: from wip_preference_values v1
89: where v1.preference_id = p_pref_id and
90: v1.level_id = v.level_id
91: )
92: order by v.level_code desc

Line 111: from wip_preference_values wpv

107:
108: BEGIN
109: select wpv.attribute_value_code
110: into l_result
111: from wip_preference_values wpv
112: where wpv.preference_id = p_pref_id and
113: wpv.level_id = p_level_id and
114: rownum = 1;
115: Exception

Line 1190: from wip_preference_values wpv

1186: p_attribute_name IN VARCHAR2,
1187: p_attribute_val IN VARCHAR2) return NUMBER IS
1188: CURSOR pref_row_seq_csr IS
1189: select wpv.sequence_number
1190: from wip_preference_values wpv
1191: where wpv.preference_id = p_pref_id
1192: and wpv.level_id = p_level_id
1193: and wpv.attribute_name = p_attribute_name
1194: and wpv.attribute_value_code = p_attribute_val;

Line 1210: from wip_preference_values wpv

1206: p_seq_num IN NUMBER,
1207: p_attribute_name IN VARCHAR2) return VARCHAR2 IS
1208: CURSOR att_val_csr IS
1209: select wpv.attribute_value_code
1210: from wip_preference_values wpv
1211: where wpv.preference_id = p_pref_id
1212: and wpv.level_id = p_level_id
1213: and wpv.sequence_number = p_seq_num
1214: and wpv.attribute_name = p_attribute_name;