DBA Data[Home] [Help]

APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on WSH_SHIPPING_PARAMETERS

Line 220: FROM wsh_shipping_parameters

216:
217: -- 5601081
218: CURSOR get_shipping_parameters(p_org_id IN number) IS
219: SELECT default_stage_locator_id, pick_grouping_rule_id
220: FROM wsh_shipping_parameters
221: WHERE organization_id = p_org_id;
222:
223: -- 5601081
224: CURSOR get_sales_order_id(p_header_id IN number) IS

Line 733: -- need to get location_id and pick_grouping rule_id from wsh_shipping_parameters

729: FETCH get_move_order_header INTO l_ic_mo_header_rec;
730: CLOSE get_move_order_header;
731: GMI_RESERVATION_UTIL.PrintLn('in move order header id and attribute15 '|| to_char(l_ic_mo_header_rec.header_id)||' and '||l_ic_mo_header_rec.attribute15);
732:
733: -- need to get location_id and pick_grouping rule_id from wsh_shipping_parameters
734: -- for grouping_rule_id for MO header and for to_locator_id for MO line -- 5601081
735: OPEN get_shipping_parameters(move_order_line_rec.organization_id);
736: FETCH get_shipping_parameters INTO l_to_locator_id,l_grouping_rule_id;
737: CLOSE get_shipping_parameters;