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: -- 13243594 added to_char for mtl.segment1 and oe.order_number

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

733: FETCH get_move_order_header INTO l_ic_mo_header_rec;
734: CLOSE get_move_order_header;
735: 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);
736:
737: -- need to get location_id and pick_grouping rule_id from wsh_shipping_parameters
738: -- for grouping_rule_id for MO header and for to_locator_id for MO line -- 5601081
739: OPEN get_shipping_parameters(move_order_line_rec.organization_id);
740: FETCH get_shipping_parameters INTO l_to_locator_id,l_grouping_rule_id;
741: CLOSE get_shipping_parameters;