[Home] [Help]
857: -- because for WIP putaway where cost group will be derived later, so
858: -- comingle_check will fail if cost_group_id is NULL
859: -- Bug 2886342. Add Or condition of p_mmtt.cost_group_id IS NOT NULL
860: -- This is the cases when cost group suggestion has been stamped on MMTT
861: -- which will be transferred to MOQD or WMS_LPN_CONTENTS later.
862: -- assign_cost_group will not be called, so need to do the comingling check here
863: IF (l_skip_comingle_check = 2)
864: AND((curlpnrec.cost_group_id IS NOT NULL)
865: OR(p_mmtt.cost_group_id IS NOT NULL)) THEN
972: -- because for WIP putaway where cost group will be derived later, so
973: -- comingle_check will fail if cost_group_id is NULL
974: -- Bug 2886342. Add Or condition of p_mmtt.cost_group_id IS NOT NULL
975: -- This is the cases when cost group suggestion has been stamped on MMTT
976: -- which will be transferred to MOQD or WMS_LPN_CONTENTS later.
977: -- assign_cost_group will not be called, so need to do the comingling check here
978:
979: IF (l_skip_comingle_check = 2)
980: AND((curlpnrec.cost_group_id IS NOT NULL)
5373: ELSE
5374: --lpn is same as transfer lpn just need to null the source name,
5375: --source header id and cost group columns for all items inside
5376: --that lpn.
5377: UPDATE wms_lpn_contents
5378: SET source_name = NULL
5379: , source_header_id = NULL
5380: , cost_group_id = NULL
5381: WHERE parent_lpn_id = p_lpn_id;
5467: );
5468: ELSE
5469: --lpn is same as transfer lpn just need to null the cost group column
5470: --for all items inside that lpn.
5471: UPDATE wms_lpn_contents
5472: SET cost_group_id = NULL
5473: WHERE parent_lpn_id = p_lpn_id;
5474:
5475: --Same needs to be done in the serial numbers table
5729:
5730: -- For the case where the from_lpn_id = to_lpn_id, then need
5731: -- to manually update COST_GROUP_ID, as we are not calling Pack in this case
5732: IF (p_lpn_id = p_transfer_lpn_id) THEN
5733: UPDATE wms_lpn_contents
5734: SET cost_group_id = p_cost_group_id
5735: WHERE organization_id = p_organization_id
5736: AND inventory_item_id = p_inventory_item_id
5737: AND parent_lpn_id = p_lpn_id