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

Line 48: from wip_preference_values wpv

44: l_comp_calc_type NUMBER;
45:
46: CURSOR cat_set_id_csr IS
47: select wpv.attribute_value_code
48: from wip_preference_values wpv
49: where wpv.preference_id = g_pref_id_comp_short
50: and wpv.level_id = g_pref_level_id_site
51: and wpv.attribute_name = g_pref_val_comp_type_cset_att;
52:

Line 231: from wip_preference_values wpv

227: FUNCTION get_pref_comp_cat(p_org_id NUMBER) return VARCHAR2 IS
228: cat_string VARCHAR2(1048);
229: CURSOR pref_cat_csr IS
230: select wpv.attribute_value_code
231: from wip_preference_values wpv
232: where wpv.preference_id = g_pref_id_comp_short
233: and wpv.level_id = g_pref_level_id_site
234: and wpv.attribute_name = g_pref_val_comp_type_cat_att
235: and wpv.sequence_number in (

Line 237: from wip_preference_values wpv1

233: and wpv.level_id = g_pref_level_id_site
234: and wpv.attribute_name = g_pref_val_comp_type_cat_att
235: and wpv.sequence_number in (
236: select wpv1.sequence_number
237: from wip_preference_values wpv1
238: where wpv1.preference_id = g_pref_id_comp_short
239: and wpv1.level_id = g_pref_level_id_site
240: and wpv1.attribute_name = g_pref_val_comp_type_att
241: and wpv1.attribute_value_code = to_char(g_pref_val_comp_type_cat)

Line 244: from wip_preference_values wpv2

240: and wpv1.attribute_name = g_pref_val_comp_type_att
241: and wpv1.attribute_value_code = to_char(g_pref_val_comp_type_cat)
242: and wpv1.sequence_number in (
243: select wpv2.sequence_number
244: from wip_preference_values wpv2
245: where wpv2.preference_id = g_pref_id_comp_short
246: and wpv2.level_id = g_pref_level_id_site
247: and wpv2.attribute_name = g_pref_val_dtl_org_att
248: and wpv2.attribute_value_code = to_char(p_org_id)));

Line 267: from wip_preference_values wpv

263: FUNCTION get_pref_comp_id(p_org_id NUMBER) return VARCHAR2 IS
264: comp_string VARCHAR2(1048);
265: CURSOR pref_itm_csr IS
266: select wpv.attribute_value_code
267: from wip_preference_values wpv
268: where wpv.preference_id = g_pref_id_comp_short
269: and wpv.level_id = g_pref_level_id_site
270: and wpv.attribute_name = g_pref_val_comp_type_item_att
271: and wpv.sequence_number in (

Line 273: from wip_preference_values wpv1

269: and wpv.level_id = g_pref_level_id_site
270: and wpv.attribute_name = g_pref_val_comp_type_item_att
271: and wpv.sequence_number in (
272: select wpv1.sequence_number
273: from wip_preference_values wpv1
274: where wpv1.preference_id = g_pref_id_comp_short
275: and wpv1.level_id = g_pref_level_id_site
276: and wpv1.attribute_name = g_pref_val_comp_type_att
277: and wpv1.attribute_value_code = to_char(g_pref_val_comp_type_item)

Line 280: from wip_preference_values wpv2

276: and wpv1.attribute_name = g_pref_val_comp_type_att
277: and wpv1.attribute_value_code = to_char(g_pref_val_comp_type_item)
278: and wpv1.sequence_number in (
279: select wpv2.sequence_number
280: from wip_preference_values wpv2
281: where wpv2.preference_id = g_pref_id_comp_short
282: and wpv2.level_id = g_pref_level_id_site
283: and wpv2.attribute_name = g_pref_val_dtl_org_att
284: and wpv2.attribute_value_code = to_char(p_org_id)));

Line 466: from wip_preference_values wpv

462:
463: FUNCTION is_all_component_selected(p_org_id NUMBER) RETURN BOOLEAN IS
464: CURSOR all_item_pref_csr IS
465: select wpv.attribute_value_code
466: from wip_preference_values wpv
467: where wpv.preference_id = g_pref_id_comp_short
468: and wpv.level_id = g_pref_level_id_site
469: and wpv.attribute_name = g_pref_val_comp_type_att
470: and wpv.sequence_number in (

Line 472: from wip_preference_values wpv1

468: and wpv.level_id = g_pref_level_id_site
469: and wpv.attribute_name = g_pref_val_comp_type_att
470: and wpv.sequence_number in (
471: select wpv1.sequence_number
472: from wip_preference_values wpv1
473: where wpv1.preference_id = g_pref_id_comp_short
474: and wpv1.level_id = g_pref_level_id_site
475: and wpv1.attribute_name = g_pref_val_dtl_org_att
476: and wpv1.attribute_value_code = to_char(p_org_id));

Line 561: ' from wip_preference_values wpv ' ||

557: --l_item_clause := ' msi.inventory_item_id in (:inv_item_ids)';
558: --l_sql := l_sql || l_item_clause;
559: l_item_clause := 'msi.inventory_item_id in ( '||
560: ' select wpv.attribute_value_code ' ||
561: ' from wip_preference_values wpv ' ||
562: ' where wpv.preference_id = :pref_id_comp_short1 ' ||
563: ' and wpv.level_id = :pref_level_id_site1 ' ||
564: ' and wpv.attribute_name = :pref_val_comp_type_item_att1 ' ||
565: ' and wpv.sequence_number in ( ' ||

Line 567: ' from wip_preference_values wpv1 ' ||

563: ' and wpv.level_id = :pref_level_id_site1 ' ||
564: ' and wpv.attribute_name = :pref_val_comp_type_item_att1 ' ||
565: ' and wpv.sequence_number in ( ' ||
566: ' select wpv1.sequence_number ' ||
567: ' from wip_preference_values wpv1 ' ||
568: ' where wpv1.preference_id = :pref_id_comp_short2 ' ||
569: ' and wpv1.level_id = :pref_level_id_site2 ' ||
570: ' and wpv1.attribute_name = :pref_val_comp_type_att2 ' ||
571: ' and wpv1.attribute_value_code = to_char(:pref_val_comp_type_item2) ' ||

Line 574: ' from wip_preference_values wpv2 ' ||

570: ' and wpv1.attribute_name = :pref_val_comp_type_att2 ' ||
571: ' and wpv1.attribute_value_code = to_char(:pref_val_comp_type_item2) ' ||
572: ' and wpv1.sequence_number in ( ' ||
573: ' select wpv2.sequence_number ' ||
574: ' from wip_preference_values wpv2 ' ||
575: ' where wpv2.preference_id = :pref_id_comp_short3 ' ||
576: ' and wpv2.level_id = :pref_level_id_site3 ' ||
577: ' and wpv2.attribute_name = :pref_val_dtl_org_att3 ' ||
578: ' and wpv2.attribute_value_code = to_char(wro.organization_id))) )';

Line 904: ' from wip_preference_values wpv ' ||

900: if(l_item_ids is not null) then
901: --l_item_clause := ' msi.inventory_item_id in (:inv_item_ids)';
902: l_item_clause := 'msi.inventory_item_id in ( '||
903: ' select wpv.attribute_value_code ' ||
904: ' from wip_preference_values wpv ' ||
905: ' where wpv.preference_id = :pref_id_comp_short1 ' ||
906: ' and wpv.level_id = :pref_level_id_site1 ' ||
907: ' and wpv.attribute_name = :pref_val_comp_type_item_att1 ' ||
908: ' and wpv.sequence_number in ( ' ||

Line 910: ' from wip_preference_values wpv1 ' ||

906: ' and wpv.level_id = :pref_level_id_site1 ' ||
907: ' and wpv.attribute_name = :pref_val_comp_type_item_att1 ' ||
908: ' and wpv.sequence_number in ( ' ||
909: ' select wpv1.sequence_number ' ||
910: ' from wip_preference_values wpv1 ' ||
911: ' where wpv1.preference_id = :pref_id_comp_short2 ' ||
912: ' and wpv1.level_id = :pref_level_id_site2 ' ||
913: ' and wpv1.attribute_name = :pref_val_comp_type_att2 ' ||
914: ' and wpv1.attribute_value_code = to_char(:pref_val_comp_type_item2) ' ||

Line 917: ' from wip_preference_values wpv2 ' ||

913: ' and wpv1.attribute_name = :pref_val_comp_type_att2 ' ||
914: ' and wpv1.attribute_value_code = to_char(:pref_val_comp_type_item2) ' ||
915: ' and wpv1.sequence_number in ( ' ||
916: ' select wpv2.sequence_number ' ||
917: ' from wip_preference_values wpv2 ' ||
918: ' where wpv2.preference_id = :pref_id_comp_short3 ' ||
919: ' and wpv2.level_id = :pref_level_id_site3 ' ||
920: ' and wpv2.attribute_name = :pref_val_dtl_org_att3 ' ||
921: ' and wpv2.attribute_value_code = to_char(wro.organization_id))) )';

Line 1145: from wip_preference_values wpv

1141: and bdr.resource_id = wor.resource_id
1142: and bdr.department_id = nvl(wor.department_id, wo.department_id)
1143: and wor.resource_id in (
1144: select distinct to_number(wpv.attribute_value_code) resource_id
1145: from wip_preference_values wpv
1146: where wpv.preference_id = g_pref_id_res_short
1147: and wpv.attribute_name = 'resource'
1148: and wpv.level_id = 1
1149: and wpv.sequence_number in (

Line 1151: from wip_preference_values wpv_org

1147: and wpv.attribute_name = 'resource'
1148: and wpv.level_id = 1
1149: and wpv.sequence_number in (
1150: select wpv_org.sequence_number
1151: from wip_preference_values wpv_org
1152: where wpv_org.preference_id = g_pref_id_res_short
1153: and wpv_org.attribute_name = 'organization'
1154: and to_number(wpv_org.attribute_value_code) = p_org_id))
1155: order by resource_id;