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_WS_SHORTAGE

Line 1397: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));

1393: l_shortage_calc_level NUMBER;
1394: BEGIN
1395: --Bug 6889755 - Return component shortage depending on the calculation level setup
1396: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1397: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));
1398:
1399: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1400: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);
1401: --End Bug 6889755

Line 1400: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);

1396: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1397: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));
1398:
1399: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1400: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);
1401: --End Bug 6889755
1402:
1403: --Bug 6889755 - added IF condition and the ELSE block for subinv level check
1404: /* Bug 9221212 , remove rownum =1 as we should consider the shortage_qty