DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on MTL_PARAMETERS

Line 130: FROM mtl_parameters

126: -- that value so that the same number will not be used again the next time
127: -- Generate_LPN is called for that org
128:
129: SELECT lpn_starting_number INTO l_lpn_start_num
130: FROM mtl_parameters
131: WHERE organization_id=p_org_id
132: FOR UPDATE;
133:
134: UPDATE MTL_PARAMETERS

Line 134: UPDATE MTL_PARAMETERS

130: FROM mtl_parameters
131: WHERE organization_id=p_org_id
132: FOR UPDATE;
133:
134: UPDATE MTL_PARAMETERS
135: SET lpn_starting_number = l_lpn_start_num+p_qty,
136: last_update_date = SYSDATE,
137: last_updated_by = FND_GLOBAL.USER_ID
138: WHERE organization_id = p_org_id;