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.

[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_PREFERENCE_VALUES

Line 923: from wip_preference_values wpv

919: ) return varchar2
920: Is
921: cursor c_pref_values(p_pref_id number, p_level_id number) IS
922: select wpv.attribute_name, wpv.attribute_value_code
923: from wip_preference_values wpv
924: where wpv.preference_id = p_pref_id and
925: wpv.level_id = p_level_id
926: order by wpv.sequence_number;
927:

Line 1141: from wip_preference_values v1, wip_preference_values v2, wip_preference_values v3, wip_preference_values v4

1137: v1.attribute_value_code,
1138: v2.attribute_value_code,
1139: v3.attribute_value_code,
1140: v4.attribute_value_code
1141: from wip_preference_values v1, wip_preference_values v2, wip_preference_values v3, wip_preference_values v4
1142: where
1143: v1.preference_id = p_pref_id and
1144: v2.preference_id = p_pref_id and
1145: v3.preference_id = p_pref_id and

Line 1231: from wip_preference_values wpv

1227: is
1228:
1229: cursor c_pref_values(p_pref_id number, p_level_id number, p_attribute varchar2) IS
1230: select wpv.attribute_value_code
1231: from wip_preference_values wpv
1232: where wpv.preference_id = p_pref_id and
1233: wpv.level_id = p_level_id and
1234: ( p_attribute is null
1235: or wpv.attribute_name = p_attribute);